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 |
|
anurupr
Starting Member
2 Posts |
 Posted - 2010-12-04 : 04:19:37
|
| I made a C# .net application which uses a SQL server 2005 database. after i install the application , i keep getting this error . I've tried 'ALTER LOGIN' sql statement but it has not worked .Can anyone help me? |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2010-12-04 : 08:13:57
|
to grant access to the db..exec sp_grantdbaccess 'databasename','loginname'set the default db exec sp_defaultdb 'loginname','databasename'
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
anurupr
Starting Member
2 Posts |
Posted - 2010-12-04 : 08:17:41
|
| well i tried that but that didnt work either.. i did try changing the built-in account property of the SQL server in the SQL server configuration manager to Local system rather than local service and it works now |
|
|
|
|
|
|
cannot open user default database. Login failed