SQL 2005 Express Login - SQL Server Forums

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"

micky--4444
Starting Member

19 Posts

Posted - 2007-04-10 : 04:24:44

how do I check that?

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"

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?

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources