MDSE setup and use. 1

[ironhide1975]

Greetings,

I have setup MSDE on my laptop as I trying to get a version of one of my web applications (ASP classic) to be portable for our company's DM's on the road. I am able to in stall MSDE, and copy the database over from a pre-install of SQL Server client tools. However I am running into the following problems.

1) Although I can create a DSN to connect to the database, whenever I connect and try to pull back data with my web app the browser hands and time-outs.

2) I am unable to connect to the SQL instant on my machine from another machine. If it wasn't for a pre-install of SQL Client tools I would not have been able to copy the database over.

3) When the machine starts the SQL instance doesn't automatically run. I have to indicate the SQL instance to start.

Our attempt here is get this into some sort of setup that can distributed to various user's machines in a easy fashion. If anyone can offer advice on these problems I would appreciate it. I have tested setting up MSDE on two machines with the same problems.

Any help is greatily appreciated, thanks.

Therm-o-disc -

http://www.tod.com

 

[mrdenny]

1. Can you connect via osql or isql and get data back from the database?
2. Check the ERRORLOG. If your are running MSDE on Windows 2003 (and XP as well I think) it won't allow access from remote until it's patched to SP3 or SP3a.
3. I beleive that MSDE does not set it self to start automatically. Set the service to start automatically. It should be set to manual now.

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.

 

[ironhide1975]

Thank for your help, I will try and answer the responses as best as possible.

1) Not sure what osql or isql is, please define.
2) Running windows XP and I did install the MSDE Service patch 3 I believe.
3) I will check on services for automatic startup. The icon in the lower right hand corner appears, but there is no red dot or arrow. Its just blank, and even when I set it up and it reads "Autostart service..." it still will return to that status when I reboot the machine.

Thank you again for your help.

Therm-o-disc -

http://www.tod.com

 

[mrdenny]

1. osql and isql are command line programs used to connect to SQL servers. They should be in your path statement. If not they will be in the ./binn folder in the folder you installed SQL Server. use osql /? or isql /? to get the paramaters.

2. Make sure you installed the SP Version for msde, not for the full blown SQL Server. sp2kdesksp3.exe is the name of the file for MSDE.

3. In the Service Applet in the Administrative Tools. If it's not on your Start Menu, it's in the control pannel. The service name is MSSQLSERVER. Check there to set it to automatic.

If the ./log folder there is a file called ERRORLOG. Look through that for any errors, or you can email it to me. You can send it to mrdenny@ gamespy.com.

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.

 

[ironhide1975]

1) I am able to get a command prompt, but what do I do after I type in osql /? or isql /?. I get a list of help commands? No listing of these apps in the ./binn folder.

2) I'm pretty sure I downloaded the most recent version of MSDE, but just in case, I will search on Microsoft's site just to follow up.

3) I do not have a MSSQLSERVER, however I do have a MSSQL$PEAPOD service running, set to Automatic.

Once again your help is greatily appreciated. I will respond via email as well.

Therm-o-disc -

http://www.tod.com

 

[ironhide1975]

Doubled checked the installer's folder is named. sql2ksp3

Therm-o-disc -

http://www.tod.com

 

[mrdenny]

OK, so you've got MSDE installed as an instance other than the default instance.

isql and osql are command line utilities. Use them to try to connect to the remote sql install. The ./binn folder will probally be in c:\program files\Microsoft SQL Server\MSSQL$PEAPOD

osql -S RemoteMachine\PEAPOD -U sa -P password -d YourDataBase -Q "select count(*) from sometable"

That should connect to the remote machine and download the data. Run in from a command prompt. Make changes as needed to the machine name, password, database name, and table name.

If you were able to install a named instance then you have the current version. But you will still need to install the service pack. The sql2kdesk.exe is the name of the service pack file to download.

If the service is set to automatic, then it should be starting on boot. Next time you reboot the computer, after it comes back up, check the service first off, and see if it's running. The service manager next to the clock is probally looking for the default instance, not the named instance you have installed.

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.

 

[ironhide1975]

You Rock! I installed the service pack and it worked. (I believe it was from the Service Pack. I also modified the Devices: Unsigned driver installation behavior in the Local Security Policy.) Thank you very much.

Therm-o-disc -

http://www.tod.com

 

[mrdenny]

no problem.

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.