Problem connecting to sql server 2008 database from sql server 2005 express..

[Nisha Agrawal]

Nada Adel wrote:

Do I have to download sql server 2008 on my pc to connect to the database remotely instead of sql server 2005?

yes, u r right. u can't connect to sql server 2008 via sql server 2005. i also faced this problem. and in fact sql server 2005 express can not upgraded to sql server 2008 so first u have to uninstall sql server 2005 then install sql server 2008.

[Nada Adel]

thanks a lot, I'll install sql server 2008 and try again.

[Nada Adel]

I have a feeling that the server name is not correct. How can I get the correct server name to connect to? I have access to the server, can you tell me how to get the server name if I want to connect remotely??

[Nada Adel]

I've just installed sql server 2008 but still not working. I have a feeling that the server name is not correct. Can you tell me how to write the server name?? I have access to the server and the database on the server. When I access the database locally I write for example ("MyServer,portnumber") but remotely, I can't seem to access it using the same server name.

[Henry Minute]

You might try visiting ConnectionStrings.com[^], a very useful site. I know that you are not using a connection string but the site shows many variations on the machinename/servername combination.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Nada Adel]

I've tried everything. Still cannot connect. I used the IP address of the server but still can't connect. Is there anything I can do on the server to enable remote connection..I've done everything I can thing of..am I missing something?

[Nisha Agrawal]

have u enabled TCP/IP Connection on the server? it's required to connect it remotely.

[Henry Minute]

For SQL Server 2005 Microsoft link[^] For SQL Server 2008 link to thread from someone with similar problems to yourself[^] Hope these help! :)

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Nada Adel]

yes I did...but the default port is not 1433, it is set to another port - 1512. So I added that port to firewall exceptions. I just wanna make sure I did this right. I added a rule for the port 1512. It is a TCP not UDP right?

[michelle sollicito]

I have seen a lot of people all over the web with this same problem so I will let you know how I fixed my problem with it and maybe it will help someone! Firstly, go into IIS Manager and click on your website or directory.. on the right hand panel there is a connection strings option - dbl click on it and it will tell you what your default local sql server is set to.. somehow mine got all screwed up so that was part of my problem.. hopefully that is ALL of your problem (some of you anyhow).. ;-) For me it was more complex however.. I was also trying to do personalization for anonymous users. Thus, in my web.config there were two sets of connection strings.. one was labelled thus: <appSettings> <add key="ConnectionString" value="server=localhost;database=caleb.mdb;uid=;password=;" /> </appSettings> ..so I thought I was using MS Access.. but there was another Connection String attribute like this.. Somewhere else I found this kind of connection string.. <connectionStrings> <add name="LocalhostCTP6" connectionString="Data Source=localhost;Initial Catalog=CTP6;User ID=dnn;Password=dnn" providerName="System.Data.SqlClient" /> <add name="DynamicConnection" connectionString="Data Source=localhost;Initial Catalog=CTP6;User ID=dnn;Password=dnn" /> </connectionStrings> <appSettings> <add key="ConnectionInfo" value="server=(local);database=Northwind;Integrated Security=SSPI" /> </appSettings> (see this article[^] If you arent sure which connection string is actually being used by your program, you can use this code.. [^] ..and to complicate things more, an external file can be involved too as it was in my case!! <appSettings file="testlabsettings.config"/> and as if things werent already complicated enough it is possible to add connection strings on the fly at run time see http://www.kodyaz.com/articles/add-connection-string-to-web-configuration-file.aspx[