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.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 SQL 2005 Express Login

Author  Topic 

micky--4444
Starting Member

19 Posts

Posted - 2007-04-10 : 03:33:40
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
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-10 : 03:46:54
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 - 2007-04-10 : 04:24:44
how do I check that?
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-10 : 04:30:00
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 - 2007-04-10 : 05:39:36
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

84 Posts

Posted - 2007-04-10 : 11:12:53
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
   

- Advertisement -