Can't Generate SSPI

Hi,
I'm trying to configure a Windows Authentication SQL Server user and I get a
message that the compuetr can;t generate an SSPI connection. The Enterprise
Manager then won't connect to the SQL Server. The VS.NET 2003 enviroment, w
hich is the user preferred
connection enviroment to the SQL Server also won't connect.
The user has SQL Server 2000 Develop edition SP3a installed on the computer
and we are trying to connect to a SQL Server 2000 Enterprise edition SP3a. T
he user also has on his computer VS6 and VS.NET 2003.
Does any one know the cause of this problems?
Thanks,Try these links:
http://www.sqlservercentral.com/col...kb;en-us;811889
Ray Higdon MCSE, MCDBA, CCNA
--
"Shai Goldberg" <gshai(removethis)@.shamir.co.il> wrote in message
news:B52289F3-1E9F-410F-B49C-BCB73C80D1AD@.microsoft.com...
> Hi,
> I'm trying to configure a Windows Authentication SQL Server user and I get
a message that the compuetr can;t generate an SSPI connection. The
Enterprise Manager then won't connect to the SQL Server. The VS.NET 2003
enviroment, which is the user preferred connection enviroment to the SQL
Server also won't connect.
> The user has SQL Server 2000 Develop edition SP3a installed on the
computer and we are trying to connect to a SQL Server 2000 Enterprise
edition SP3a. The user also has on his computer VS6 and VS.NET 2003.
> Does any one know the cause of this problems?
> Thanks,|||Thanks,sql

Can't connect to SQL Server Express 2005 using localhost in the connection string.

However it works perfectly if I specify the full server name like this
192-55-55-55\SQLEXPRESS.
Is there any way to configure it so I would be able to connect to it using
localhost?
Thank you,
VladTry using . (dot) as in .\SQLEXPRESS. localhost may or may not be
configured.
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
"Vlad Kryvokobylsky" <vlad.kryvokobylsky@.denovosoftware.com> wrote in
message news:%23jqbiTOCHHA.4892@.TK2MSFTNGP04.phx.gbl...
> However it works perfectly if I specify the full server name like this
> 192-55-55-55\SQLEXPRESS.
> Is there any way to configure it so I would be able to connect to it using
> localhost?
> Thank you,
> Vlad
>|||Local host is set up properly, since I can use it in IE.
The idea is to avoid using a server instance name. Just an IP address.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ek4NI$OCHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Try using . (dot) as in .\SQLEXPRESS. localhost may or may not be
> configured.
> --
> 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
> "Vlad Kryvokobylsky" <vlad.kryvokobylsky@.denovosoftware.com> wrote in
> message news:%23jqbiTOCHHA.4892@.TK2MSFTNGP04.phx.gbl...
>

Can't connect to SQL Server Express 2005 using localhost in the connection string.

However it works perfectly if I specify the full server name like this
192-55-55-55\SQLEXPRESS.
Is there any way to configure it so I would be able to connect to it using
localhost?
Thank you,
Vlad
Try using . (dot) as in .\SQLEXPRESS. localhost may or may not be
configured.
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
"Vlad Kryvokobylsky" <vlad.kryvokobylsky@.denovosoftware.com> wrote in
message news:%23jqbiTOCHHA.4892@.TK2MSFTNGP04.phx.gbl...
> However it works perfectly if I specify the full server name like this
> 192-55-55-55\SQLEXPRESS.
> Is there any way to configure it so I would be able to connect to it using
> localhost?
> Thank you,
> Vlad
>
|||Local host is set up properly, since I can use it in IE.
The idea is to avoid using a server instance name. Just an IP address.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ek4NI$OCHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Try using . (dot) as in .\SQLEXPRESS. localhost may or may not be
> configured.
> --
> 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
> "Vlad Kryvokobylsky" <vlad.kryvokobylsky@.denovosoftware.com> wrote in
> message news:%23jqbiTOCHHA.4892@.TK2MSFTNGP04.phx.gbl...
>

Cant connect to SQL server

I have a SQL server hosting version 2005 and support ASP.net 2.0. Evrerything works just fine with other databases. However when I use Web Configure supported in Visual Studion 2005 to define the membership and user control and upload all files and folders to the server. It never works. I says can not connect to SQL server. The help guy from my hosting says it does not support SQL express and they do not support that.

By default the database connection string is configured by SQL express and I do not know how to change it.

Not all, it is said that just upload everything to the server and that's all but it is not that. To work with database I had to use SQL server 2005 to upload the database by using import wizard and import tables into the database folder in my server. Do I need to do them same with membership and role database? I tried but it still says error .

I am just beginer so need help form you, the masters.

The URL show error is www.tinhtran.com/Default.aspx

thanks

Hi,

take a look at this site for connectionstrings. Personally, I find it strange that you don't get the correct connectionstring from the helpdesk.

Grz, Kris.