NEED HELP/SQL UPGRADE/PLEASE!

Tried to upgrade to 2.0 last night, and am running into a major difficulty getting SO Admin to talk to SQL Server 2005. My error message is "SQL Server does not exist or access denied. Connection open (Connect())"

I have been on the phone with Microsoft Tech Support for most of the day (and we have been running the store without a computer, which is no mean feat). Have installed and removed SQL 2005 several times, checked to make sure everything is running and started, that everything that is supposed to be is enabled.....any insights out there?

By the way, it would be a good idea to mention to folks that they need a certain amount of RAM to upgrade to SQL 2005; we had to add more RAM to our computer this morning.....only to find that we can't get it up and running anyway....

Thanks in advance, Kat

Reply to
Kat Straub
Loading thread data ...

Reply to
convoluted

When I did the upgrade I didn't uninstall MSDE, I just let the installation upgrade it and had no problems. Where I ran into problems was if I tried to install Express2005 on my own and not letting the 2.0 disk do the install. When I tried to do it several months ago using the download from MS I had the same problem, I couldn't get it to connect. I had a query program on my computer and I had to use it to find my installed instance of SQLExpress. Once I figured out the name of the instance I was able to connect. Just recently I upgraded MSDE with the 2.0 disk and connected instantly. I think the difference was when I tried to do it myself I set up a named instance(I didn't know any better). When 2.0 sets it up it uses an unnamed instance I believe. Craig

Reply to
Craig

Craig is probably correct that you have installed a named instance rather than a default instance, but there are a couple of other possibilities.

Are you trying to connect SO Administrator from the computer running SQL

2005, or from a remote system? If from a remote system, you have probably not enabled remote connections to the server, or you may not have started the SQL Browser service. You can do both of these things from the SQL Server Surface Area configuration tool, which will be available on the system running SQL Server. You may have additional problems from a remote system if you have not installed the correct client components on each remote system. You can find these by searching the Microsoft site for "Feature pack for SQL Server": SQL Native Client, MSXML6, Backward compatibility components. I'm not sure if the RMS 2.0 installer loads these for you or not. Honestly, I'm so unimpressed with MS recently that I haven't bothered to install 2.0 yet.

If you are trying to connect locally on the SQL Server, there are a couple of things that you can try:

1) Log into Windows as an Administrator, then try to connect using Windows Authentication. If this works, it probably means that you have forgotten the sa password that you set during SQL Server install. (This is not likely as you would probably see a different message). 2) Open SQL Server Configuration Manager (It's available from All Programs/SQL Server 2005/Configuration Tools) and check that the following services are running: SQL Server Browser, SQL Server(InstanceName). If the instance Name is "MSSQLSERVER", I believe that you have a default instance, meaning that you do not need to specify an Instance name in you connection settings. If it is anything else, such as "SQLEXPRESS", then you need to add that to you Server Name in SO Admin: on the local system this would be "(local)\InstanceName", one a Remote it would be either "ServerName\InstanceName" or "192.168.1.2\InstanceName" - obviously you would substitute the correct IP Address for the SQL Server...

Hope that helps!

Glenn Adams Tiber Creek C> Tried to upgrade to 2.0 last night, and am running into a major difficulty

Reply to
Glenn Adams [MVP - Retail Mgmt

Glenn,

I appreciate your feedback. Finally have the 2.0 upgrade (and the store up and running!) on the front "local" computer......and although I haven't had time to play around on it, it looks like there are one or two things that are different and definitely helpful in manager (as far as day-to-day operations go; we'll see if I get to find new bugs as well).

Now, of course, I have to get the back "remote" computer going. The two computers are networked together, but I am having a hard time figuring out what server name to use to point to that local POS computer and connect to admin/manager via that computer. Does this make sense?

I did the first two steps you suggested--enabling the browser and allowing for local and remote connections, enabled TCP/IP and named pipes, etc. I will look for those backward compatability components now. However, I am guessing that I just don't know the correct server name to point to the correct computer. How do I figure that out? I am getting the same error message I did yesterday; now on the back computer. SQL 2005 and all 2.0 updates are on this back computer as well as the front; I just want the programs to talk to each other.

Anyways, thanks again for your help. I am actually curious as to why you are unimpressed with MS recently?

S> Craig is probably correct that you have installed a named instance

Reply to
Kat Straub

The server name under SO Admin on your back office machine is the full computer name of the front POS machine. To find this info:

on front comp>

click start button>

right click on my computer>

properties>

computer name tab>

full computer name (exclude the dot at the end)>

inut full computer name of POS in SO Admin of back office machine.

Reply to
jocelynp

If you connect SO Admin (File/Connect) on the server, it should display the server name in the lower left corner... Jocelyn's methods also work. When in doubt, assign the server a static IP Address and use that numeric IP address as the server name.

Glenn Adams Tiber Creek C> Glenn,

Reply to
Glenn Adams [MVP - Retail Mgmt

I am also having problems with the upgrade. I am on the server trying to get the local setup going. I'm good until I try to connect to the database for the upgrade database portion. I get the error message unable to login - login failed.

Help

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
sbfeed

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.