HI,
We upgraded to SQL Server 2005 Standard Edition for our ASP.NET 2.0 website. We were using SQL Server Express 2005. That worked fine. Now we are unable to connect to the database. I have googled, but I just cann't figure out what is going on. Any help is appreciated. Here is the error.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
In our firewall sqlbrowser.exe and sqlservr.exe are allowed.
Thanks Matt
Matt,
I have seen this error everytime I install MS SQL 2005, you need to enable TCP/IP as by default is not
Open the program -> SQL Server Surface Configuration
Go To -> Surface Area Configuration and Connections
Go To -> Remote Connections
and change Local Connections only to
Local and Remote connections
|||
AL,
Thank you for the quick reply. I did what you said and it was configured to,
Local and Remote Connections
Using both TCP/IP and named pipes,
already.
My databases reside inside my App_Data folder in my ASP.NET 2.0 application.
Do you have any other ideas?
Could it be my connection string?
Thank you again.
Matt
|||Matt,
My biggest apologies, I jump to the answer as I have seen this message more than once. Again sorry.
If you already configured that, and you open all the ports on the firewall, I do not remember the port number but you can test from one computer to the other by opening a dos box and doing
telnet servername portnumber
If connects, you are good!! If does not ... open the port in the firewall
|||Al,
Thank you again for helping me. I think that it is my fault. I don't think I have given you enough information about my situation.
I am trying to move my asp.net 2.0 website from sql server express to sql server 2005 standard edition.
So far all I have done is uninstall sql express and then installed sql server 2005.
I configured sql server 2005 with, what I assume to be the standard setup. I just used the wizard and did not change anything else. Those settings from the previous post were what was already checked when you told me to look at them. I did not set them.
I think from the little bit of research I have done, that I cann't use the AttachDbFile feature that sql express uses for sql server 2005?
At this point I am completely lost and frustrated. I am fairly new to this and trying hard to figure it out.
I do appreciate the help.
Any suggestion or ideas?
Thank You Again
Matt
|||Actually attaching the database is the best solution. Also check on the logins after attaching that the username and password are correct. You can use VS2005 to connect to a database to see if that test works, there is a great wizard with great errors that might tell you what the problem is.
Besides that I am pretty lost, should work :-(
|||Al,
Thank you for the help. I got it to work with one database. I used the wizrd and it worked great.
I also created a user in sql server 2005. I gave it a bunch of permissions just to get it to work. I think I should narrow thoses down to only the ones it needs.
My only other question is, I ran the aspnet_regsql.exe and it created a database in sql server 2005. But I was unable to use the ASP.NET Configuration tool to create roles and users. I made the same type of connection as with my other database. Error below.
The following message may help in diagnosing the problem:A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Any ideas?
Thank You Again
Matt
|||When you use ASP.NET Configuration, make sure you give it a connection string that will work on the NEW DATABASE for users and roles. If you connect to the new database, you'll see the providers tab|||Al,
Thanks again. I got it all working now. It was the connection string.
Thanks
Matt
|||Did you figure it by going to ASP.NET Configuration?
Glad you fix it! Stick around!
|||
No, I worked through it on a post by scottgu. I had .mdf in my connectionstring. When I removed .mdf, it made the connection.
Thanks Matt
|||Ah! Mr Guthrie's blog is like a gold mine!
No comments:
Post a Comment