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.
| Author |
Topic |
|
hameed
Starting Member
40 Posts |
 Posted - 2002-04-29 : 07:56:45
|
| I have file and printer sharing turned on the sql server (MS SQL Server 2000 SP2) that I am using for all my asp sites (the websites are obviously on a different box) and if I turn it off (file and printer sharing), all the websites that connect to this server because of a some database can no longer connect This is the error message I get if I turn off file and printer sharing:ErrorDataCurrent Time:4/28/2002 5:28:20 PMError number:Source:Microsoft OLE DB Provider for SQL ServerPage:/includes/connect.aspSourceCode:No code availableLine:6Column:-1Short Description:[DBNMPNTW]ConnectionOpen (CreateFile()).Long Description:Remote Address:64.7.71.118Remote Host:64.7.71.118Local Address:64.7.70.something (i changed this deliberatly)Query string:Form stringThis is obviously a huge security risk and I need to understand this better.Can someone please help?ALSO, what is port 445 open for on the server? Is is to allow me to connect via the SQL Enterprise Management Console? |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-29 : 10:41:11
|
| Just a shot in the dark, but I bet is has to do with the fact that you are connecting with Named Pipes. [DBNMPNTW] I would try switching the connection type to TCP/IP. [DBMSSOCN]Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
connection failure to sql server when file and pri