-
Failed to connect to SQL server 2005 instance
Hi:
I have a SQL 2005 instance (standard edition with sp2 on windows 2003 server) located on different domain.
I can connect to it by using sa only. I need to use SQL login.
I created another user called 'test' and granted with sysadmin server role, but I got following error:
Login failed for user 'test'. (Microsoft SQL Server, Error: 18456)
I searched on the internet two days with no luck.
Any idea?
Thanks in advance.
Theresa
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|