Re: Issue with Admin in Sql Server 2005

Make sure that the account you use for your PeopleSoft service has permissions to create databases in your SQL Server instance

"saw" <swexpress(remove)@hotmail.com> wrote in message news:#LgWAMriIHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
I am allowing PeopleSoft to create the database for me.

Thank you for your reply. I really hope to get this working soon.

"bass_player" <bass_player@xxxxxxxx> wrote in message news:OFJ0cjmiIHA.1168@xxxxxxxxxxxxxxxxxxxxxxx
Are you creating the database using SQL Server Management Studio or you are allowing PeopleSoft to create the database for you?

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message news:#bqlJUmiIHA.5956@xxxxxxxxxxxxxxxxxxxxxxx
saw
CREATE LOGIN saw WITH password='jj'
XEC master..sp_addsrvrolemember @loginame = N'saw', @rolename = N'sysadmin'


CREATE USER saw FOR LOGIN saw

Please see BOL for more details





"saw" <swexpress(remove)@hotmail.com> wrote in message news:eJQ9ibiiIHA.5280@xxxxxxxxxxxxxxxxxxxxxxx
I am new to SQL Server 2005. Here's my issue:

I am installing PeopleSoft with SQL Server 2005 backend. When I try to create the database it is giving me an error message Msg 5123 operating system error (Access is denied) while attempting to open or create the physical file 'C:/program files/EP_data.mdf'..

Can someone tell me the steps in setting up an user/login with the proper credentials to create an database.

Is this related to security or something as I am not sure.

Any help is appreciated.





.

Relevant Pages

  • Issue with Admin in Sql Server 2005
    ... I am installing PeopleSoft with SQL Server 2005 backend. ... create the database it is giving me an error message Msg 5123 operating ... credentials to create an database. ...
    (microsoft.public.sqlserver.security)
  • Re: get external data odbc limitation?
    ... SQL database not a MDB ... PeopleSoft (whether linked via ODBC or "downloaded" via an Access "make ... college office software in use) & time savings in using Access Jet ...
    (microsoft.public.access.externaldata)
  • Re: Issue with Admin in Sql Server 2005
    ... I am allowing PeopleSoft to create the database for me. ... CREATE USER saw FOR LOGIN saw ... create the database it is giving me an error message Msg 5123 operating ...
    (microsoft.public.sqlserver.security)
  • Re: Issue with Admin in Sql Server 2005
    ... Are you creating the database using SQL Server Management Studio or you are allowing PeopleSoft to create the database for you? ... When I try to create the database it is giving me an error message Msg 5123 operating system error while attempting to open or create the ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing PeopleSoft Database from .NET
    ... systems, including Oracle, Informix, IBM DB2, Sybase, ... PeopleSoft application is using, and program against that. ... > How to access the peoplesoft database from the .NET application. ... > be authenticated for accessing the peoplesoft applications. ...
    (microsoft.public.dotnet.framework.aspnet)