I am glad I could help.

🙂

The question is posted in the wrong section and the actual question is wrong because connection is not per server but per database. The only way another application will...

I hope you actually installed it because this feature is not automatic but you said you have used it so the service maybe off in configuration manager turn it on...

I think it is a separate ranking system I am currently a newbie there, I think it is fun to answer some questions.

You need to install management studio Express which I think also installs the SAC(surface area configuration tool) which you could use to enable local and remote, both TCP/IP and Named...

It will be easier to move the application to 10g RC2 and then to 2005 because both are easy to integrate with limited issues, while 9i will require some rewrites.

I am glad I could help.

🙂

No it can be fixed by changing the connection pooling code and making sure the connection object is disposed...

Check the thread below for the correct way to configure SSRS 2005.

http://www.sqlservercentral.com/Forums/Topic693668-147-1.aspx

That is correct check below for more about the stored procedure and the poster does not understand ANSI SQL requirements because the connection context of transaction was changed in SQL...

I have all you need will find the relevant thread and edit my post. Here are the two links you need for migration, upgrade and recovery from disaster.

http://msdn.microsoft.com/en-us/library/ms156421(SQL.90).aspx

http://support.microsoft.com/?kbid=842425

There are two reasons for this error which means SQL Server does not know the user which could even be an application runtime as Asp.net or SSRS. So if you...

Actually NO because you also need the ReportServerTemp DB to recover because the migration tool must extract some information from both databases. And you also need both to upgrade...

The definition of the two types of temp table is not the issue but rather what the code is doing in the application because definition is not relevant SSRS parser...

If remember correctly name of instance is not relevant because since 2000 days some shops only installs named instances. And in 2005 you could change the name of the...