Installing and using Developer 2005

I am currently having problems with the SQL Server 2005 Developer.

1. I have a Windows XP SP2 Japanese version.

2. This machine is connected to a domain managed by Linux server.

3. I login with a domain account and install.

Initially, the intallations were failing with an error message that I do not have

administrator right.

We created an account on my machine with the same user name as that used

for the domain, and gave this administrator rights.

With this the installation was completed. However, there is another problem,

I cannot connect to the SQL Server.

For the installation, I chose "Local System" with Windows Authentication,

but the connection to the database still fails with the error message that remote

connection is not supported. I do not understand why I need TCP to accesss a local

installation of the SQL Server.

However, I followed the procedure outlined in a MS KB to enable TCP. But the

connection to the database still fails.

I am using the Management Studio to connect to SQL Server. I have also tried creating

a database in VS. NET 2005 and this also fails. I have checked the services and all are running.

What is wrong and what can I do? (it takes more than an hour to install this stuff and it is

really consuming my time). Any help?

Best regards,

Paul.

Actually you are missing a lot the Developer edition and Express comes locked down you have to go in and enable all you need with the Configuration Manager and Surface area configuration tool. It also helps if you use both TCP/IP and Named Pipes. I have covered all in the last posting in the thread below, the instructions are for Express and the developer edition but ignore the server registration section. I would also recommend mixed authentication mode so VS2005 will not cause you problems during development. Post again if you still need help.

http://msdn2.microsoft.com/en-us/library/ms188670.aspx

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1869763&SiteID=1

|||

Thanks for the reply.

I mentioned in my post, I followed the MS KB to enable the TCP. To be precise, it is this KB

http://support.microsoft.com/kb/914277

That never helped or solved the connection problem.

That KB starts like...

"When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive an error message."

I installed "Local System" and do not see how this statement applies to my case when I am only trying to use the SQL Server on the same machine.

Best regards,

Paul.

|||

I have found the problem. I was connecting to the server listed and not the localhost.

Best regards,

Paul.