Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jumbuck
Starting Member
11 Posts |
 Posted - 2009-04-22 : 16:21:19
|
| I have a program that uses Integrated Security to connect successfully to a database in the development environment, the connection string being @"Data Source=.\SQLEXPRESS;AttachDBFilename=" + <DatabaseFile with path> + ";Integrated Security=True;User Instance=True;";The program can be downloaded and installed by targeted end users, but end users running the downloaded program can't access the database, and instead get the following error:CREATE Database permission denied in database 'master' An attempt to attach an auto-named database for file <DatabaseFile with deployed path>failed. A database with the same name exists, or specified file cannot be opened, or is located on UNC share.If I substitute "Database" for "AttachDBFilename" in the connecton string in the development computer, and download and install the amended program, end users now get the following error:Cannot open database<DatabaseFile with deployed path> requested by the login. The login failed. Login failed for user \<end user computer name>\<end user name>What should I do to enable end users to connect to the database? |
|
|
|
|
|
Connection String for DB to be deployed