SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 SQL 2005 Express Login		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

micky--4444
Starting Member

19 Posts
Posted - 04/10/2007 :  03:33:40  Show Profile  Reply with Quote
Hello,

I'm trying to log into a remote SQL Server but get: Login Failed for user
'XXXXXXXX' and I also get the 18456 error.

The host company assure me they are the right logins and curiously when I use Visual Web Developer and the data connection I can access the database tables etc.

I am using TCP/IP

any ideas what might be going wrong?

thanks.

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts
Posted - 04/10/2007 :  03:46:54  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
What is the service pack status of said SQL Server?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

micky--4444
Starting Member

19 Posts
Posted - 04/10/2007 :  04:24:44  Show Profile  Reply with Quote
how do I check that?
Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts
Posted - 04/10/2007 :  04:30:00  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
Using,

select @@version


or ask the SQL Server admin.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

micky--4444
Starting Member

19 Posts
Posted - 04/10/2007 :  05:39:36  Show Profile  Reply with Quote
I downloaded the latest SP 2 and installed it.

Still no luck, any ideas?
Go to Top of Page

mikewa
Microsoft SQL Server Product Team

USA
84 Posts
Posted - 04/10/2007 :  11:12:53  Show Profile  Reply with Quote
Hi Micky,
You've likely not configured either SQL Express or your computer to accept remote connections. Follow the instructions in http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 to do this.

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000