May 20, 2009 at 12:16 pm
hi I'm having a problem with logging into sql server 2005 using a new database and log in that i created in sql 2005.
the error that i got . it says that my new user cannot log on to the server. I'm doing this because i want to link my
quality center to my database that i created in sql. i am pretty new to this so if there is someone who can give me
an idea of how to log in into my new database let me know. thank you
May 20, 2009 at 2:00 pm
You created the DB first with a Domain Admin or SA Account. After that you created a new login in SQL Server. Am I right? Did you create a user in the database and map it to the login that you just created and give the appropriate rights?
-Roy
May 20, 2009 at 4:24 pm
sigh. cross post. 🙁
http://www.sqlservercentral.com/Forums/Topic720958-391-1.aspx
I asked on other thread if its in mixed mode.
---------------------------------------------------------------------
May 20, 2009 at 7:50 pm
yes i did, and i am having the same problem.
May 20, 2009 at 9:35 pm
The other thread is closed, please answer here.
What error are you getting? You haven't posted an error.
If it's the "server does not exist", then your service is not running or you have a firewall blocking things. If it's "login failed", you have the wrong user name and/or password.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply