SQL Server 2005 Developer on Windows Vista Home Premium

[Zaafir]

Hello friends,

On my Windows Vista Home Premium I recently installed SQL Server 2005 Developer edition. I done it with using the built-in account with Windows authentication. IIS/SSRS issue aside, ll components installed successfuly.When I use the SQL Server 2005 User Provisioning Tool to make my PC login as an administrator,it end up on error. Verified that all services for the specified instance are up and running and checked the log for any errors. All services are running.SO I enabled TCP/IP and Named Pipes.The log states Dedicated admin connection support was established for listening locally on port 49384.but the port listed on the error message is 2383. Am thinking could be this is the trouble maker

any helps.!!

[Big Fish]

My guess is that it might be related to Admin level permissions since the VS2005 team tells you to use only Admin rights but the SQL Server team reminds you to use lower level permissions which curb what you can do in Vista.

[Steve123]

Brother,are you attempting to connect to remote SQL server or to the local instance?.Have you installed SQL Server as default or named instance? If its default then give a static port number, restart the service, exclude the port from firewall and then attempt connecting to sql server.

[Spyrus]

Well i had similar issues with the 2008. there is nothing in VS 2008 which can stop SQL Server from working. Have you checked in Services under Control Panel>administrative tools that all SQL Server related services are running?.moreover, before installing VS 2008, was your SQL Server running?