[thelist] SQL Server: making the connection
Asif Suria
asifsuria at yahoo.com
Tue Nov 27 18:04:39 CST 2001
I have had a similar problem before and was able to
get this working by switching from Named Pipes to
TCP/IP. (I still have no idea why Named Pipes used to
work before and then suddenly stopped working one
day.)
However I would not recommend using both Windows NT
and SQL Server authentication as there is a security
hole associated with this dual mode of authentication.
Microsoft issued a patch for the flaw and you can find
more information on this at (watch for URL wrap)
http://zeus.itworld.com:9000/Sec/2210/MS-SecurityholeinSQL318/
Asif
--- Susan Wallace <susanhw at vonl.com> wrote:
> I went to Ent. Manager, in Security checked "Windows
> NT and SQL Server
> Auth" (NT Only was checked before)
> Restarted the SQL service
> Now functions properly.
>
__________________________________________________
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
More information about the thelist
mailing list