Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

server problems

Status
Not open for further replies.

mmarkym

Programmer
Mar 23, 2002
54
US
This is all being done on my local computer. I have some websites I'm trying to view in IIS 5, and am also using SQL server to access databases using ADO from those websites via a connection string.

I've had the websites viewable from IIS (although only from my computer, from another computer I get "page can not be displayed"). Now I can't view them from either remote or local computer.

On SQL server, I can't seem to get the connection string right. When I was able to view my websites from my Local computer as stated above, I was trying to connect to a database with a connection string that gave me different errors each time I tried different connection strings. The most common error was can't find server or unauthorized login.

Now that I can't view my webs I can't really check the connection strings anymore.

Any help would be appreciated.

Mark
 
Assuming you are able to connect into sqlserver, without the connection string, we really cannot help you.

data source=serverhere;persist security info=True;initial catalog=datbasehere;user id=userhere;password=passwordhere;

this is an example of a connection string i use and works for a sqlserver login. nt uses a different one.
 
I'm now set up in sql to windows NT. What would be the connection string in windows NT.

mark
 
Here is one i use for nt auth

"Data Source=serverhere;initial catalog=databasehere;Integrated Security=SSPI;persist security info=False;"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top