Hello,

1. Did you create a connection object before trying to open it?

2. Try the connection string from VBscript to make sure connection string works independently from you .NET application. let us...

Steve,

good article.

One comment for everyone:

Many of us install SQL Server as a database server for the third-party applications. Application vendors mostly develop when running SQL Server on Local...

You have to find out how they can automatically send pages if it is could be done automatically. If this is the case you can output messages into text files...

This is what I found so far except for Impersonate advice:

this is from

http://www.talkaboutsoftware.com/group/microsoft.public.sqlserver.connect/messages/41047.html

who is replying to her own question:

Very Good!

Do you use HOUDBSQL01P\HOUDBSQL01P as a server name when trying to connect or in the Client / network utility? It is obvious that you have installed Named Instance so...

Hi,

I always make the following error:

I do have good user mappings. Say, mylogin to mylogin, or mylogin - impersonate etc. in the Linked Server Properties. BUT... I have a server...

Les,

In addition to posting here several entries for the port and protocol from the SQL Server Error log from the startup part of the log as Balmukund asked you may...

Rudy,

Changing the port is cool!

I also had cases not upgrade related but requiring Single User like for database restore: the single user condition could not be reached because the web...

If it is MSDE than you have to enable network protocols first. If it is not MSDE, use Server Network utility and check the port. After that create an entry...

Did you try to move data from your secured database into a new MS ACCESS database without any security on the machine with the MDW file? Then move this new...

You may use

sp_MSforeachdb

to perform tasks on each database. See

http://www.sqlservercentral.com/columnists/achigrik/sql2000.asp

SQL Server 2000 Useful Undocumented Stored Procedures

by Alexander Chigrik  here on this site

This is a good plan to add entries to DNS to point the new server. Is the IP address changing? You have to account for the users who connect by...

I assume that you can use  new environmental variable or a UDF function to define a long path string depending on what you are doing This is an example with...

I would not recommend doing that.

First, you don't know how Microsoft programmers coded changing collation

Second, you may change data by changing collation

I would recommend to create another column withthe correct...

Theoretically, there is no Correct Answer in the selection:

BOL for SQL Server 2005 says:

"  ¹Important   Microsoft recommends that you not use the ......... account for the SQL Server or the...