After applying the changes mentioned in KB 914277 to allow remote connections, while working in Visual Studio 2005, I'm now getting an error with the number 26: Error locating server/Instance specified...
Sure wish I knew what remote means in this scenario, as there is nothing "remote" about my installation. I only have 1 computer, the one i'm working on, where SQL Server and Visual Studio are installed, and no networks involved, so what is remote?
Any help would be appreciated!!
If the sql server you are trying to connect to and the app you are running are on the same physical machine then you do not need to config remote connections.
Can you check if the SQL Server is still running via the services.msc or config manager first of all.
|||If there is a way of telling SQL Server that I don't need any remote connection, I'd be more than happy to use it.
However I don't know how to do that... therefore I got the error-message about the remote connection.
How do I tell SQL Server there is no need for a remote connection?
Thanx!!
|||Use the surface area config tool|||And then...
Check what, click what, do what?
I've only been able to install SQL Server, with a lot of coaching from this forum, I've never used it, and have no idea what makes it or any of it's utilities tick...
I'm thankful for any advice I've been given, but I have no idea what to do with the Surface Area tool, when I get there...
|||Hello Layne - I got your e-mail about still not being able to connect. Without more information, this will be hard for everyone to help you with. But before I give you some more pointers, you should know about a couple of things.
First, this isn't the primary mechanism for support for Microsoft products. Everyone here is happy to help out where we can, but it's a free site where Microsoft and other database folks will try and help you. We'll do what we can to help you, but there are no guarantees. Microsoft hosts these sites (again, at no cost to you) but this isn't the primary method they support their products. If you need immediate assistance you can check out several support options at http://www.microsoft.com/support.
I also think the comments in your e-mail to me about "all of us going back to India" isn't very polite. If you're asking for help (for free), you may want to be complimentary rather than derogatory. It will get you more answers faster to be polite to others.
The best place for you to look for what you're asking is:
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
It's on Express, but will help you with your edition as well.
|||If the problem is just remote connection is not allowed on the remote server read and check whether the remote server is configured as in the following article http://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx but it seems that you are hitting another problem
No comments:
Post a Comment