| Author |
can't conect remotely to SQL Express
|
|
|
| I am connecting remotely to SQL Express using my VB application. Here is the
connection string that I use.
cn.ConnectionString = " Provider=SQLNCLI;Net
work Library=DBMSSOCN;Int
egrated
Security=SSPI;"Server=192.168.10. 243\SQLEXPRESS,1433;
" & _
" database=CopyRequest
"
I get "Login failed for user 'ILYA-TEST-PC\Guest'" error when I try to
connect. What is the cause of this error? I allow remote connections on SQL
Server.
| |
| John Bell 2006-03-14, 3:23 am |
| Hi
Have you checked the permissions for 'ILYA-TEST-PC\Guest' ?
John
"Ilya" wrote:
> I am connecting remotely to SQL Express using my VB application. Here is the
> connection string that I use.
>
> cn.ConnectionString = " Provider=SQLNCLI;Net
work Library=DBMSSOCN;Int
egrated
> Security=SSPI;"Server=192.168.10. 243\SQLEXPRESS,1433;
" & _
> " database=CopyRequest
"
>
> I get "Login failed for user 'ILYA-TEST-PC\Guest'" error when I try to
> connect. What is the cause of this error? I allow remote connections on SQL
> Server.
| |
| Roger Wolter[MSFT] 2006-03-15, 3:23 am |
| Guest is disabled by default. I assume you're not logged in as guest when
you try to make the connection so this error means you are connecting as a
Windows user who doesn't have permissions or can't be authenticated to the
local Windows machine. Get Windows security working and I think it will
work.
--
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
"Ilya" <Ilya@discussions.microsoft.com> wrote in message
news:6CAFF2A5-3273-4E28-AFEB- 07060DFFE503@microso
ft.com...
>I am connecting remotely to SQL Express using my VB application. Here is
>the
> connection string that I use.
>
> cn.ConnectionString = " Provider=SQLNCLI;Net
work
> Library=DBMSSOCN;Int
egrated
> Security=SSPI;"Server=192.168.10. 243\SQLEXPRESS,1433;
" & _
> " database=CopyRequest
"
>
> I get "Login failed for user 'ILYA-TEST-PC\Guest'" error when I try to
> connect. What is the cause of this error? I allow remote connections on
> SQL
> Server.
|
|
|
|