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 |
|
lakhva
Starting Member
22 Posts |
 Posted - 2005-03-28 : 01:37:10
|
| helloI Detached the user default database from the server (Using EM) and when i was attaching the database,there is a problem. Enter prise Manager is working but In a servergroup, a particular server is not opened(Expand). It shows the error as cannot open user default database, Login failed, i can not even enter inside using sa login because I don't know the password for SA account.I Know i've to change the default database for my account but How can I do this?Can anyone please help me out?thanx in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-28 : 14:24:08
|
| Are you using Windows Authentication or SQL Authentication when connecting?Tara |
 |
|
|
lakhva
Starting Member
22 Posts |
Posted - 2005-03-28 : 17:58:25
|
| Hi,I've SQL Authentication . I work from home remotely so i can't have windows authentication. Also I inhertied this application from a company with NO DBA to guide me or tell me anything that's why I don't know password for SA. I tried using blank as a password for SA but it doesn't work. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-28 : 19:15:15
|
| Well you'll either need to find out the sa password, another sql account that has sysadmin rights, or use windows authentication of an account that has local admin on the database server. Using either of these, you'll be able to get into the SQL instance to change the default database of the user that you are using.Tara |
|
|
|
lakhva
Starting Member
22 Posts |
Posted - 2005-03-29 : 01:44:24
|
| Hi Tara,Yes I'm using SQL Authentication. I did check the logins in the past and i remember that builatin/administrators account does exist to get connected with windows authentication but I never got connected using that. I work remotely from home and I'm not a DBA so i really don't know how can i get connected with sql server remotely working from home using windows authentication. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-29 : 16:32:11
|
| You'll need to talk with someone who isn't connected remotely and who is a local administrator on the database server. This person can connect to Enterprise Manager using Windows Authentication and fix the default database for you in Security/Logins.Tara |
|
|
|
lakhva
Starting Member
22 Posts |
Posted - 2005-03-29 : 17:29:23
|
| Hi Tara,I found a person who could access server locally and he was able to change my default database to master. Thanks a lot for your help! |
|
|
|
|
|
|
cannot open user default database error