Re: why only sa can connect to SQL server 2005 instance?
- From: "William Vaughn" <billvaNoSPAM@xxxxxxxxx>
- Date: Fri, 17 Aug 2007 08:55:35 -0700
Check out my blog. There are a couple of whitepapers there that discuss connecting issues. If that does not help, come back.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Theresa" <Theresa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1E78BC89-5F64-487B-82E9-D1DBF2E67645@xxxxxxxxxxxxxxxx
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 via SQL server management studio. 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.
.
- Prev by Date: Re: Unable to connect to SQL 2000 engine on other machine from SSM
- Next by Date: Can't connect to SQL Express using Windows Authentication
- Previous by thread: Re: why only sa can connect to SQL server 2005 instance?
- Next by thread: Can't connect to SQL Express using Windows Authentication
- Index(es):
Relevant Pages
|
