Named Pipes Provider

Hi!

I tryed to make an silent mode install for SQL express edition, for example:

start/ wait setup.exe /qn ADDLOCAL=ALL SECURITYMODE=SQL SAPWD=***** SQLBROWSERAUTOSTART=1 DISABLENETWORKPROTOCOLS=0

When i run it from a .bat file it's ok but i'm using this command in a .ini file in some apllication.
It doesn't install all the SQL, i mean in services it appears only SQL Server VSS Writer.
I also get the error Named Pipes Provider. The application that i want to install gets installed but can't connect to server.
I really need some help.

Seems your server is not installed at all. If no server is running, you will see the Named Pipes Provider error. So, make your server is installed first. How do you initiate the setup from a .ini file?

Named Pipers Provider, error 40, ok from local, error to remote - help

Hi.
I am new to sql server so please bear with me.
Here is the problem.
I am using VWD express to connect to a sql server 2005 db on my local
machine. The site and the sql server are local and everything is fine.
No problems.
I have a sql server hosting plan to host the db. (my local is SQL
Server 2005 and the hosted is Sql Server 2000).
I use the LOCAL VWD website to access the HOSTED sql server and it
connects with no problem. I changed data in the remote version of the
db as a double-check that I am accessing the remote db and not the
local db.
When I go ahead and upload the web site to my web host, different from
the sql host (long story), I get this error (provider: Named Pipes
Provider, error: 40 - Could not open a connection to SQL Server).
Any ideas why this error is happening. My web host verifies that my
connection string is fine, and that if I can connect with my local
machine then there should be no problem and the problems is on the
hosting end.
Thanks in advance,
RanginaldOk. Problem solved. I was using a web host with multiple hosted
domains and I think I probably had some kind of IIS app directrory
problem. I moved the site to its own hosting and all was fine with no
changes needed.
Thanks anyway. Hope this tidbit helps someone.
Rangy
Ranginald wrote:
> Hi.
> I am new to sql server so please bear with me.
> Here is the problem.
> I am using VWD express to connect to a sql server 2005 db on my local
> machine. The site and the sql server are local and everything is fine.
> No problems.
> I have a sql server hosting plan to host the db. (my local is SQL
> Server 2005 and the hosted is Sql Server 2000).
> I use the LOCAL VWD website to access the HOSTED sql server and it
> connects with no problem. I changed data in the remote version of the
> db as a double-check that I am accessing the remote db and not the
> local db.
> When I go ahead and upload the web site to my web host, different from
> the sql host (long story), I get this error (provider: Named Pipes
> Provider, error: 40 - Could not open a connection to SQL Server).
> Any ideas why this error is happening. My web host verifies that my
> connection string is fine, and that if I can connect with my local
> machine then there should be no problem and the problems is on the
> hosting end.
> Thanks in advance,
> Ranginald|||Do you have to connect with named pipes? If not, change the connection string
to connect with TCP/IP (set Network Library=dbmssocn). Assuming that the SQL
connectivity components are properly installed on the web server and you can
ping the database server from the web server, I'd try a few things.
1. Find out the IP address and the TCP port that the SQL instance listens on.
2. Change the connection string to the IP address followed by a comma and
then the TCP port (e.g. set Server=169.12.35.51,5002). If this does not work,
you may have a problem with accessing the port. (if it's the default instance
using the default port, you don't need to test with the port number specified
explicitly).
3. Change the IP to the server name in the Server property of the connection
string, and try again. If this doesn't work, you may have a problem with
resolving the server to the IP address. Try the fully qualified domain name
instead.
If you can connect with TCP/IP, but not with names pipes, you may have a
problem with the ports used by the named pipes being blocked.
Linchi
"Ranginald" wrote:
> Hi.
> I am new to sql server so please bear with me.
> Here is the problem.
> I am using VWD express to connect to a sql server 2005 db on my local
> machine. The site and the sql server are local and everything is fine.
> No problems.
> I have a sql server hosting plan to host the db. (my local is SQL
> Server 2005 and the hosted is Sql Server 2000).
> I use the LOCAL VWD website to access the HOSTED sql server and it
> connects with no problem. I changed data in the remote version of the
> db as a double-check that I am accessing the remote db and not the
> local db.
> When I go ahead and upload the web site to my web host, different from
> the sql host (long story), I get this error (provider: Named Pipes
> Provider, error: 40 - Could not open a connection to SQL Server).
> Any ideas why this error is happening. My web host verifies that my
> connection string is fine, and that if I can connect with my local
> machine then there should be no problem and the problems is on the
> hosting end.
> Thanks in advance,
> Ranginald
>|||How would I find out the TCP port that the SQL instance listens on?
Thanks
Linchi Shea wrote:
> Do you have to connect with named pipes? If not, change the connection string
> to connect with TCP/IP (set Network Library=dbmssocn). Assuming that the SQL
> connectivity components are properly installed on the web server and you can
> ping the database server from the web server, I'd try a few things.
> 1. Find out the IP address and the TCP port that the SQL instance listens on.
> 2. Change the connection string to the IP address followed by a comma and
> then the TCP port (e.g. set Server=169.12.35.51,5002). If this does not work,
> you may have a problem with accessing the port. (if it's the default instance
> using the default port, you don't need to test with the port number specified
> explicitly).
> 3. Change the IP to the server name in the Server property of the connection
> string, and try again. If this doesn't work, you may have a problem with
> resolving the server to the IP address. Try the fully qualified domain name
> instead.
> If you can connect with TCP/IP, but not with names pipes, you may have a
> problem with the ports used by the named pipes being blocked.
> Linchi
> "Ranginald" wrote:
> > Hi.
> >
> > I am new to sql server so please bear with me.
> > Here is the problem.
> >
> > I am using VWD express to connect to a sql server 2005 db on my local
> > machine. The site and the sql server are local and everything is fine.
> > No problems.
> >
> > I have a sql server hosting plan to host the db. (my local is SQL
> > Server 2005 and the hosted is Sql Server 2000).
> >
> > I use the LOCAL VWD website to access the HOSTED sql server and it
> > connects with no problem. I changed data in the remote version of the
> > db as a double-check that I am accessing the remote db and not the
> > local db.
> >
> > When I go ahead and upload the web site to my web host, different from
> > the sql host (long story), I get this error (provider: Named Pipes
> > Provider, error: 40 - Could not open a connection to SQL Server).
> >
> > Any ideas why this error is happening. My web host verifies that my
> > connection string is fine, and that if I can connect with my local
> > machine then there should be no problem and the problems is on the
> > hosting end.
> >
> > Thanks in advance,
> > Ranginald
> >
> >sql

Named Pipers Provider, error 40, ok from local, error to remote - help

Hi.
I am new to sql server so please bear with me.
Here is the problem.
I am using VWD express to connect to a sql server 2005 db on my local
machine. The site and the sql server are local and everything is fine.
No problems.
I have a sql server hosting plan to host the db. (my local is SQL
Server 2005 and the hosted is Sql Server 2000).
I use the LOCAL VWD website to access the HOSTED sql server and it
connects with no problem. I changed data in the remote version of the
db as a double-check that I am accessing the remote db and not the
local db.
When I go ahead and upload the web site to my web host, different from
the sql host (long story), I get this error (provider: Named Pipes
Provider, error: 40 - Could not open a connection to SQL Server).
Any ideas why this error is happening. My web host verifies that my
connection string is fine, and that if I can connect with my local
machine then there should be no problem and the problems is on the
hosting end.
Thanks in advance,
RanginaldOk. Problem solved. I was using a web host with multiple hosted
domains and I think I probably had some kind of IIS app directrory
problem. I moved the site to its own hosting and all was fine with no
changes needed.
Thanks anyway. Hope this tidbit helps someone.
Rangy
Ranginald wrote:
> Hi.
> I am new to sql server so please bear with me.
> Here is the problem.
> I am using VWD express to connect to a sql server 2005 db on my local
> machine. The site and the sql server are local and everything is fine.
> No problems.
> I have a sql server hosting plan to host the db. (my local is SQL
> Server 2005 and the hosted is Sql Server 2000).
> I use the LOCAL VWD website to access the HOSTED sql server and it
> connects with no problem. I changed data in the remote version of the
> db as a double-check that I am accessing the remote db and not the
> local db.
> When I go ahead and upload the web site to my web host, different from
> the sql host (long story), I get this error (provider: Named Pipes
> Provider, error: 40 - Could not open a connection to SQL Server).
> Any ideas why this error is happening. My web host verifies that my
> connection string is fine, and that if I can connect with my local
> machine then there should be no problem and the problems is on the
> hosting end.
> Thanks in advance,
> Ranginald

Named Instances Problem (I Think)

I'm struggling a little with this. I hope someone can help.

Ho do i install SQL Server 2005 Express so i can connect to it with "localhost", not "<MACHINE_NAME>/SQLEXPRESS". I cant seem to find any obvious setting in setup.

Could anyone shed any light on this?

Regards,

Anthony

I think you want to connect only to default instance in that case just specify the instance name as default while installing sql express refer, http://msdn2.microsoft.com/en-us/library/ms143722.aspx

|||

You can use an alias configured on the clients to connect to the name only. See the BOL for more information about configuring aliases. You will have to use the SQL Server configuration manager.

Jens K. Suessmeyer

http://www.sqlserver2005.de

MySQL

Is SQL Server Express the same as MySQL?

MySQL is a totally different product and it's not even from Microsoft. A simple Google search could have told you this too tbh.

MySQL

Is SQL Server Express the same as MySQL?

MySQL is a totally different product and it's not even from Microsoft. A simple Google search could have told you this too tbh.

My Whole installation is hosed

There is a new Management Studio Express CTP download available at http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en.

This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting. With the update, Management Studio Express and Books Online no longer interfere with each other.

To update Management Studio Express CTP:

1) Uninstall Management Studio Express CTP from your machine.
2) Clear your browser's download cache. If you are using Internet Explorer 6, you can do this by starting Internet Explorer, clicking the Tools | Options menu item, and then clicking the "Delete Files..." button in the "Temporary Internet Files" section.
3) Download and run SQLServer2005_SSMSEE.msi (or SQLServer2005_SSMSEE_x64.msi) from the URL listed above

Either the wrong version of the Management Studio Express CTP download is being used, or the bug hasn't been fixed - as I discovered this morning.

I installed the Management Studio Express and the SQL Books Online. Once the SQL Books Online was installed the Management Studio Express would not start. When I remove the SQL Books Online, the Management Studio Express works just fine.

Could you please check to ensure that the current build of both the Management Studio Express and the Books Online are both the latest builds and let us know when the correct version(s) is available?

Many thanks,

Flavelle|||

I've verified that after installing Management Studio Express CTP from the download site (dated November 11, 2005) and Books Online on a clean machine, Management Studio Express does start.

Only if some version of SQL Server 2005 Management Studio is installed will Management Studio Express not start, and in that event a message box explaining that Management Studio Express cannot run is displayed.

Make sure sqlwb.exe (the full Management Studio's executable) is not installed in your ...\Microsoft SQL Server\90\Tools\binn\vsshell\common7\ide directory. This is what the side-by-side check is looking for.

It is also possible that your web browser has a cached copy of SQLServer2005_SSMSEE.msi from a previous download which it was using. Clearing the browser's download cache might help. If you are using Internet Explorer 6, you can do this by opening IE, clicking on Tools | Options in the menu bar, then clicking the "Delete Files..." button in the "Temporary Internet Files" section. Please let us know if this fixes (or doesn't fix) the problem.

|||HI,

My installation went like this
1) My machine was not a clean install. I have June CTP on it initially. *However*, I used the clean up tool that was provided in the download area to remove any versions of the betas that already existed.
2) installed the sql server express
3) installed the above link for the Management studio

Then I tried a some old sql server script in the management studio to see compatability.

Then I woke up today and said well lets loads books and samples.

Now my Management studio will not load.

What I have done:
1) uninstalled Management Studio
2) installed Management Studio

Did not work

3) did as steven suggested
a)delete files
b)checked the ide directory - NO FILE WAS FOUND

Still did not work

4) Did what the above user stated.
*removed online books

Worked

Any other suggestions? be nice to have books online.

many thanks,

Angela|||Steven:

I verified that sqlwb.exe is not installed - not only in the directory that you suggested, but also anywhere on my machine.

Cleared all temporary files and redownloaded both the Management Studio Express CTP and the SQL Books Online and re-installed both from the new downloads.

With SQL Books Online installed, the Management Studio Express does not work at all. I am not sure what message box you are referring to - I get nothing. Checking Task Manager shows no change in the number of open processes.

The only thing that I can think of is that I did have Visual Studio 2005 Beta 2 installed on my machine, but that was removed long before I started this exercise.

Uninstalled SQL Books online and the Management Studio Express works fine. If I reinstall SQL Books Online, then Management Studio Express does not start - and I do not get any message.

Like Angela said, it would be very nice to be able to run both. Even better would be to have Help integrated with Management Studio Express from SQL Books Online, but at this point, I would happily settle for being able to run both at the same time.

Problem still exists - any more thoughts would be much appreciated.

Thanks,

Flavelle|||I installed
1. Win XP Profi
2. Net Framework 2
3. Net Framework SDK
4. Management Express CTP
(Management Studio Express CTP works ok.)
5. SQL Books Online
(Management Studio Express does not start. No error, no messagebox, no any window.)

I uninstalled SQL Books Online and it works

I have version 2005.90.1399.0 .

Jirka
|||
I uninstalled SQL Books Online and it works too

ssmsee.exe version 9.00.1399.06|||
This is the information from About that is on the SSME that I installed from the link:
Microsoft SQL Server Management Studio Express 9.00.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

The SQL Books online is version 9.00.1399.06

Hope this helps somebody, because this is becoming a Royal Pain. I am coming from an MS Access world and things are sure different in SQL Server.

Regards,

Flavelle|||Well,

I miss spoke. UNinstalling the books did get the Management Studio to come back and run.

*HOwever*, I cna no longer program in the management studio with the query analyzer portion of it. Things that were working before are no longer working...

I ma in the process of using that exe that removes betas to remove the current version of express from my computer.

I will install it yet again *just* the sqlExpress and the management studio. ANd see if that works again. Hopefully, it will..

Is there somewhere online that I can access the books lonline until this problem gets fixed?

I let you know what happened.

Many thanks!

Angela|||Well,

My whole installation is hosed unfortuantely, I am now going to try and REstore to a particular point to get my system back to the way it was.

Otherwise, I will have to spend an entire day rebuilding my system.

Just not good.

The SMSE does not work at all with the query analyzer portion. I can't even create a stored procedure or insert a row into the table.

Hopefully restoring before I put the books on will do the trick.

Let you know :(

Angela|||

When you downloaded the updated Management Studio Express, did you see it take some time to download it again, or did it start immediately? (If it starts immediately, you're running a cached copy of the Windows installer package for SSMSE.)

If you rename the "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell" registry key to "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellX" using regedit, SSMSE should start. This should not affect the stand-alone Books Online at all.

After you rename the registry key and then start Management Studio Express, does the splash Screen say "SQL Server Management Studio Express Edition" or just "Management Studio Express"? The November 11 download says "Management Studio Express."

|||Flavelle, thanks for the version information. That will help investigate this further.

Keep in mind that the Management Studio Express Community Technology Preview is a pre-release product and it isn't "fully baked" - basically it's a daily build from early November. It hasn't had the full stabilization and defect fixing treatment that the full version of SQL Server has gone through. It will be fully stabilized and defects will be fixed before it is released in the first half of 2006.

We made MSE available early to gather feedback from our Express users. Aside from just helping us find defects, we're hoping to gather feedback on how people feel about our MSE design decisions. I'm particularly interested to know how much our decision not to allow MSE to run on the same machine on which people have installed the full Management Studio impacts Express users and whether our decision not to have integrated help in MSE is a big deal to people. (We have user feedback that seems to say people who would use Express tools won't have the full tools on the same machine and that keeping the download size under 30 MB is was really important and people would be willing to give up integrated help if it reduced the download size from 120 MB to 30, which it does.)

I realize this has been pretty frustrating for early adopters, and I apologize for that. I hope there is some consolation in knowing that your feedback now is helping to improve the product when it finally ships in 2006.|||Steven:

Thanks for the information. I would like to remind you of something you said when the thread started:

This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting. With the update, Management Studio Express and Books Online no longer interfere with each other.

On the basis of what is in this thread, I would suggest that might not be the case. Mine is a relatively clean installation - I don't have Visual Studio installed yet, although it is ordered - just waiting for delivery:-)

When I receive Visual Studio, I do plan on installing it. In my case, I do not have a full SQL Server (haven't figured out how to set it up yet - that's a different story). I am a small developer, working on an application. My paying job is a Requirements Engineer and I have been working in development, requirements, and business analysis for more than 20 years. Since I have a little down time, I am going to learn SQL Server. It may kill me, but I will learn it! The SQL Express product is exactly what I need for my application. There are not a lot of managment tools for SQL Express, but the SSME seems to be good enough for my purposes.

It would be nice if it had integrated help, or if it could be hooked into SQL Books Online, and I would be quite happy to have a 120 MB file size. I also have a high-speed internet connection, so the large download is less of an issue for me than it might be for some of your other target users, so I can live without the integrated help.

What is proving very frustrating is that I cannot run both SSME and SQL Books Online. I would be perfectly happy if I could, but I cannot - and that is something that probably shouldn't wait until 2006 to fix, particularly given your statement at the start of the thread.

I am not ranting, just providing what I hope is useful feedback. If there is any more information that I can provide you, please feel free to ask - this is important to me, and I do appreciate your time and support in resolving this issue. In the meantime, please fix the problem as soon as you possibly can, because I am already going through a painful learning curve. I made the interesting discovery about how to replace the MS Access IIF() function, and I am still hoping that someone can tell me how to implement a unique constraint on a field that conforms to ANSI (allows many Null values, but only one instance of each non-Null value).

thanks,

Flavelle|||Steven:

In answer to your specific questions:

1. I downloaded from the site and saved to my local hard drive - if you would like, I will be happy to send the specific files for both SSME and BOL that I received so that you can verify that I am working with the right ones. My e-mail address is fballem@.ballemco.com. If you send me an e-mail, then I will zip and send one or both files to you, whichever would be most helpful to you.

2. I tried renaming the registry entry after installing BOL. When I started BOL, I got an error - sent the report to Microsoft using the standard method. If there is any information that I can provide you that will allow you to find this error, then please let me know. The error occurred at about 5:00 p.m. EST. I renamed the registry entry back to Shell and then uninstalled BOL. SSME works fine.

3. The splash screen is very fast, so I can't read it.

Are you having fun yet?

Regards,

Flavelle|||

Flavelle,

No problem - I appreciate your feedback.

I suspect that your web browser cache or a web proxy cache is interfering with you downloading the November 11 update and you are reinstalling the November 7 release again. You can tell which version you have by checking the creation date of the ssmsee.exe file in ...\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE. If the creation date is November 10, 2005, then you have the update. If the creation date is November 3, then you have the first release.

If you have the first release, you can use regedit to rename the "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell" key to "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellX". This will let the November 7 version of MSE run with Books Online. If MSE still can't start, then we have an unrelated problem I need to investigate further.

The only differences between the November 11 update and the November 7 release are that the November 11 release is supposed to fix the problem with starting MSE when Books Online is installed (without renaming or removing the registry key), the problem of the error message explaining why it isn't starting not appearing, and that the splash screen says "Management Studio Express" rather than "SQL Server Management Studio Express Edition" for the product name.

my Synchronization Scenario

Hi, I want to know the a solution for my Synchronization Scenario

I have a several client databses which are SQL Server 2005 Express and i have a master database which is SQL Server 2000 containing all the individual Client databases. All the individual client databases are kept seperately at the master location. I need to Synchronization the client database with its copy at the master database (something like Merge replication). Both the Client Copy as well as Master Copy could be Publishers & Subscribers.

Now the problem is Because of security & firewall issues, only the Client should have the ability to schedule & initiate the synchronization process with the master copy. Unfortunately SQL Server 2005 Express has only subscriber agent and not a publisher agent.

Any help on how to achieve this would be appreciated . Thank Youno idea, but you implimented BETA technology. Any chance you can get everything on MSDE?

my SS name changed withou re-install...strange!!

i think a lot of people using SQL Server 2005 Express has already used to use 'sqlcmd -S .\SQLEXPRESS' to login to the SS or using '.\SQLEXPRESS' as the Server Name to login in to the Management. but today i found that i cant login to my SS using '.\SQLEXPRESS', instead i must use the full name of my computer...that quite a long name and it's really inconvenient, could anyone help me out?

i think that the '.' in '.\SQLEXPRESS' is a short-cut for my computer name, but why i cant us it now? i was using it last week!

PS: what is the value of 'log on as' in ther property page of SQL Server 2005? i remember it is 'local service', but my current value is 'network service'

hi,

DavidShen wrote:

i think a lot of people using SQL Server 2005 Express has already used to use 'sqlcmd -S .\SQLEXPRESS' to login to the SS or using '.\SQLEXPRESS' as the Server Name to login in to the Management. but today i found that i cant login to my SS using '.\SQLEXPRESS', instead i must use the full name of my computer...that quite a long name and it's really inconvenient, could anyone help me out?

i think that the '.' in '.\SQLEXPRESS' is a short-cut for my computer name, but why i cant us it now? i was using it last week!

yes... "." or "(Local)" are shorkeys for the actual local computer, and they both should run...

PS: what is the value of 'log on as' in ther property page of SQL Server 2005? i remember it is 'local service', but my current value is 'network service'

these are accounts under which the actual service is run... "network service" is more limited than "local service", but they both are way to powerfull than required... you can have a look and perhaps modify the permissions "required"..

regards

|||

hi,

i can log in with 'localhost\SQLEXPRESS' or '(local)\SQLEXPRESS', but not '.\SQLEXPRESS'...really strange!! maybe there're some reg-key error, but i cant find it!!!

even though, 'localhost' and '(local)' is much shorter and easier to remember than my full computer name, i still wish to use the old way...

pllllllllllzzzzzzzzz help!

my SS name changed withou re-install...strange!!

i think a lot of people using SQL Server 2005 Express has already used to use 'sqlcmd -S .\SQLEXPRESS' to login to the SS or using '.\SQLEXPRESS' as the Server Name to login in to the Management. but today i found that i cant login to my SS using '.\SQLEXPRESS', instead i must use the full name of my computer...that quite a long name and it's really inconvenient, could anyone help me out?

i think that the '.' in '.\SQLEXPRESS' is a short-cut for my computer name, but why i cant us it now? i was using it last week!

PS: what is the value of 'log on as' in ther property page of SQL Server 2005? i remember it is 'local service', but my current value is 'network service'

hi,

DavidShen wrote:

i think a lot of people using SQL Server 2005 Express has already used to use 'sqlcmd -S .\SQLEXPRESS' to login to the SS or using '.\SQLEXPRESS' as the Server Name to login in to the Management. but today i found that i cant login to my SS using '.\SQLEXPRESS', instead i must use the full name of my computer...that quite a long name and it's really inconvenient, could anyone help me out?

i think that the '.' in '.\SQLEXPRESS' is a short-cut for my computer name, but why i cant us it now? i was using it last week!

yes... "." or "(Local)" are shorkeys for the actual local computer, and they both should run...

PS: what is the value of 'log on as' in ther property page of SQL Server 2005? i remember it is 'local service', but my current value is 'network service'

these are accounts under which the actual service is run... "network service" is more limited than "local service", but they both are way to powerfull than required... you can have a look and perhaps modify the permissions "required"..

regards

|||

hi,

i can log in with 'localhost\SQLEXPRESS' or '(local)\SQLEXPRESS', but not '.\SQLEXPRESS'...really strange!! maybe there're some reg-key error, but i cant find it!!!

even though, 'localhost' and '(local)' is much shorter and easier to remember than my full computer name, i still wish to use the old way...

pllllllllllzzzzzzzzz help!

My Sql Express is so slow?

Has anyone else noticed delays with SQL Express? I'm not really talking about delays on the queries but just delays in general response. For example: everything is running great, then for about 2 minutes I get connection timeouts etc can't even open stuff in the management studio without getting timeouts ... then as strangely as it started everything goes back to normal and requests are served again.

The server has nothing on except 1 website, its Win 2003 Server. 512MB Ram on a PIV. The memory usage is low and during the "lockups" the machine isn't showing any processor usage and SQL mem usage is around 40Megs.

I am not using User Instances either. Nothing in the event logs. What is odd, is its happening on 3 of my machines .... all with different sites, the only thing in common between them is SQL.

thanks,

-c

Are you closing and destroying your connection objects?

If you dont close and set them to nothing they will sit in the application pool taking up resources.

Just a though

My Query is not working.

I've gotten spoiled with all these query builders. Now in SQL server management studio express its gone. I don't understand whats wrong with their query...any help would be appreciated.

SELECT

[Products].myID, [ProductDetails].ShortName

FROM

[Products]

INNER

JOIN [ProductDetails]

ON

[Products].DetailID= [ProductDetails].myID

Parse comes back as
Command(s) completed successfully.

Execute comes back as
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Products'.

Closed Enterprise manager and came back in and it magically started working again.|||Make sure you're in the correct database when you execute the query In Management Studio, each query window represents a connection and can point to different databases (even differnet servers). Parse the command only means to check the syntax of your query without checking the referenced database objects. Imagine the difference between error when Parse and when execute is just like compile error VS runtime error (maybe not so exact, but should make sense)

My menubar is all messed up

Ok..this is a weird one.
When I open up SQL Server Management Studio Express my menubar has multiple
instances of the File, Edit, View...menu options... and every toolbar
(Standard, Query Designer, Database Diagram, etc..) all have multiple options
as well.
I've gone in an modified those items as well and I get it to a point where
it looks ok, then when I shut it down and re-open it, all my changes are gone
and it's back to the way it was.
Can anyone help me on this one? Is this the right place to post this
question?
Thanks in advance,
John Scott.
SQL Server 2005 stores it's configuration information in following location:
My Documents\SQL Server Management
Studio\Settings\CurrentSettings-2007-06-06.vssettings
Check to make sure there is no writing problems to that.
The path information for the config file is located at
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\90\Tools\Shell\Profile\
Thanks!
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John Scott" wrote:

> Ok..this is a weird one.
> When I open up SQL Server Management Studio Express my menubar has multiple
> instances of the File, Edit, View...menu options... and every toolbar
> (Standard, Query Designer, Database Diagram, etc..) all have multiple options
> as well.
> I've gone in an modified those items as well and I get it to a point where
> it looks ok, then when I shut it down and re-open it, all my changes are gone
> and it's back to the way it was.
> Can anyone help me on this one? Is this the right place to post this
> question?
>
> --
> Thanks in advance,
> John Scott.
|||Thank for the reply Mohit,
I checked two things...there are some goofy entries in the vssettings file
in my My Documents...file.
I made changes to it, but there is no change when I open up SQL Express...
I also checked and I don't have the
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\90\Tools\Shell\Profile\ key I have all the way up to the Shell..I
have no Profile in there.
Other suggestions?
Thanks,
John Scott.
"Mohit K. Gupta" wrote:
[vbcol=seagreen]
> SQL Server 2005 stores it's configuration information in following location:
> My Documents\SQL Server Management
> Studio\Settings\CurrentSettings-2007-06-06.vssettings
> Check to make sure there is no writing problems to that.
> The path information for the config file is located at
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\90\Tools\Shell\Profile\
> Thanks!
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "John Scott" wrote:
|||Sorry for late reply.
Sorry the proper path in registry is
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\90\Tools\ShellSEM\Profile\.
I can't get the issue to replicate. Here are two options ...
- Delete the CurrentSettings-DATE.vsssettings file.
This will force SSMSEE to reinitialize the settings. Do a search on your
computer for vsssettings delete anything with CurrentSettings in it.
OR
- Try Reinstalling the SSMSEE.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
|||Ok...I did a few things.
1. I deleted my CurrentSettings file in ssmses settings folder...when I
opened up ssmses it poped up a message saying it coudn't find my settings
folder and that it would use the most recent settings for this session
2. I checked that registry path...and i did find it, didn't find anything
out of the ordinary...it had 13 values inside that key
AutoSaveFile
AutoSaveFILETIMEHigh
AutoSaveFILETimeLow
BuildNum
DefaultSettinsDirectory
LastResetSettingsFile
SettingsCachesFILEIMEHigh
SettingsCachesFILEIMELow
Sku
TeamSettingsFile
TeamSettingsFILETIMEHigh
TeamSettingsFILETIMELow
TraackTeamSettings
for the LastResetSettingsFile the value was
'%vsspv_vs_install_directory%\Profiles\ssmsee.vsse ttings'
I checked out this file and there is a node called Caegory
name="Environment_WindowLayout"
inside it, there is another node call "PropertyVale name="WindowLayout">
then after that there is a whole bunch of garbled text (looks like viewstate
data)
then the PropertyValue node closes...
I don't know if that is normal or not...
Any other suggestions?
Thanks,
John Scott.
"Mohit K. Gupta" wrote:

> Sorry for late reply.
> Sorry the proper path in registry is
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\90\Tools\ShellSEM\Profile\.
> I can't get the issue to replicate. Here are two options ...
> - Delete the CurrentSettings-DATE.vsssettings file.
> This will force SSMSEE to reinitialize the settings. Do a search on your
> computer for vsssettings delete anything with CurrentSettings in it.
> OR
> - Try Reinstalling the SSMSEE.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
|||Delete all settings files. I would just try reinstalling though.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John Scott" wrote:
[vbcol=seagreen]
> Ok...I did a few things.
> 1. I deleted my CurrentSettings file in ssmses settings folder...when I
> opened up ssmses it poped up a message saying it coudn't find my settings
> folder and that it would use the most recent settings for this session
> 2. I checked that registry path...and i did find it, didn't find anything
> out of the ordinary...it had 13 values inside that key
> AutoSaveFile
> AutoSaveFILETIMEHigh
> AutoSaveFILETimeLow
> BuildNum
> DefaultSettinsDirectory
> LastResetSettingsFile
> SettingsCachesFILEIMEHigh
> SettingsCachesFILEIMELow
> Sku
> TeamSettingsFile
> TeamSettingsFILETIMEHigh
> TeamSettingsFILETIMELow
> TraackTeamSettings
>
> for the LastResetSettingsFile the value was
> '%vsspv_vs_install_directory%\Profiles\ssmsee.vsse ttings'
> I checked out this file and there is a node called Caegory
> name="Environment_WindowLayout"
> inside it, there is another node call "PropertyVale name="WindowLayout">
> then after that there is a whole bunch of garbled text (looks like viewstate
> data)
> then the PropertyValue node closes...
> I don't know if that is normal or not...
> Any other suggestions?
>
> --
> Thanks,
> John Scott.
>
> "Mohit K. Gupta" wrote:

MY GOD SOMEONE IS INTERESTED IN THIS FEATURE

Hi Everyone

As most of you do, I am eagerly awaiting the ability to synchronize my sql mobile database on the hand held to a local sql express database on my local machine

I know users in Microsoft have pointed out to us that we are getting things for free.

At the same time, Microsoft is getting our patience for free and at a cost to us developers.

Its nearly April and as one article says Microsoft will release a fix for this inadequacy

Microsoft...we are happy to pay for this. Palm offers it so what is the big deal. Its not the

reinvention of the wheel. We would have liked that instead of the server synchronization

that bypasses the local sql express database

I as many others are happy to pay

Please let us know when you will be addressing this problem.

I would appreciate the feedback and frustration of other developers. Maybe this will show them we are really running out of time with our clients

Regards

Touraj

Can you point to do the article that says Microsoft will release a fix for this as I am curious?|||

Still, even if someone from Microsoft hasnt said this rather than a prominent person in the MVP area, it doesnt defeat the purpose of the Topic.

We need this as our clients are screaming for this functionality.

Please just answer this simple question. WHEN?

Touraj

|||I agree that this needs to be addressed and a schedule would be helpful. I don't see why the merge/snapshot publication capability exists in MSDE 2000 but not in SQL 2005. The "free" argument breaks down when you realize that the earlier version of the database runtime could do this.|||

Hi Skip

thanks for replying

for a second i thought i was the only person interested in this feature and thought maybe i had missed something...that was until my client who is a multinational screamed at me again on the phone

Anyone....can anyone from Microsoft please tell us SOMETHING

and not ignore us. We are the customers. Please tell us anything so that we know you guys actually do read our opinions

Darren Shaffer...i really respect you....can you say anything...

Touraj

|||

Appreciate your feedback. The requirement for syncing SQL Mobile with SQL Express has been raised earlier. The issue is not that both the products are free but given the time and resources that the SQL Mobile team has can all the requirements be handled effectively. There are quite a few requirements on the plate of the team and the requirements need to be prioritized so that the maximum value is generated given the constraints. The following helps in moving things up in the priority of the Product Team:

1) The criticality of the requirement - How big is the deployment? What will happen if the feature is not made available? What is the future growth rate of the application

2) No of Applications that are affected by not having the feature - How many of the SQL Mobile Application Developer community is affected by not having this feature

3) Customer scenarios - What are the customer business scenarios that are not being solved by not having this feature

Regards

Ambrish

|||This isn't the whole picture by the way.
MSDE indeed supports merge replication, it can be configured as distributor and can make publications. I've spent quite some time making scripts to configure newly installed MSDE instance for my needs and I was quite happy with the results - MSDE made me a snapshot on given schedule.
Then it came to synchronizing with ppc... First issue is that you can't install sqlce server tools with no SQL Server installed - it just doesn't seem to be able to locate the presence of MSDE. For testing purposes I've installed SQL Server and sqlce server tools, configured IIS with it (though you can make a virtual folder with sqlce server agent and set all access rights manually). I was able to browse the site with sqlce server agent from ppc and run the agent, but when it came to synchronizing, same error appeared over and over "29045: Initializing SQL Server Reconciler has failed" on MSDE. Switching to SQL Server solves the problem - merge replication works fine, but I need same functionality with MSDE. Official documentation states that it can be done, but it doesn't points to HOW it can be done.
|||

I appreciate your feedback

I also appreciate your priortities may be different than the simple user out there.

But as a company director of a growing mobile application business I can safely say that our business is being impacted by this gap in functionality

1) The functionality of Local Sync between a hand held and SQL Express is CRITICAL

This is irrespective of the size of the project/deployment. Customers and their internal IT department are staggered and laughing at us and Microsoft when they find out its not available.

Remember this is something that is made freely available in palm desktop and should be offered.

The growth rate of our applications will soon cease to exist under the SQL mobile platform if this isnt resolved. Customers do not want devices synching with their servers via IIS.

Eg When you are dealing with Mining companies do you think there is a server out in the mine or the office. NO

There is a rugged laptop running a .NET application for which the user needs to synch information to and from his hand held. This lack of functionality has now cost us one major tender and a whole industry. So what do we do.

I wouldnt even touch Appforge. They at least offer local synch for Palm DB and Access but their scalability is poor

So where does that leave us. Very frustrated because the business is being hurt by our loyalty. So we as well as many other vendors who we have met at exhibitions are deciding to leave if this isnt addressed quick

2) Again 100% of the application developer community. I can safely say this as I have a hand on the pulse of this matter. I think without going into technical aspects, simply from a user/customer point of view this is the sole reason that we dump your technology and decide to use another one.

This is mission critical. One reason I am passionate is that you have 99% of what we need

This 1% is what is causing the 99% to be useless. I cant say it more clearer than that

3) Once again..,.I can give you 100 scenarios.

You are asking us to accept

"a user having to synch a hand held with a server. the process would leave the SQL Express out of synch as it does not partake in that process unless you trigger another synch between SQL Express and SQL Server"

Besides it being a completely poor design we cant accomplish this in scenarios like mobile sales forces, mining, telecommunications and so on when the Server isnt there to act as the middle man. I just cant understand why i even have to explain this to you guys seeing it is so obvious.

This is where you will beat IBM who is currently buying up and looking at industry specific solutions.

With Microsoft our business will soon fail to operate using your technology. Forget about being industry specific and creating solutions. They convenience of mobility is made useless if you are restricted in such a way

You can call me and I can discuss it with more factual details which I will not post here

Suffice to say that losing our company will not be a once off loss in loyatly. We are an example of the widespread dismay and frustration with SQL Mobile

Touraj

|||I'm with Touraj on this matter. For SQL Mobile direct merging with a lightweight desktop DB such as SQL Express (or MSDE) is needed very much to develop an easy-to-deploy lightweight applications|||

Thanks Zheka

I am surprised no one else is adding their thoughts to this topic

Can someone from Microsoft tell us...do we need to organise a petition

or what are the formal process to get this escalated

|||

Touraj,

By way of encouragement, I can assure you that Microsoft has heard your feedback - there have been several internal discussions I have participated in on the topic of providing merge replication with a lightweight database on the server/PC. We're talked about SQL Mobile server tools for MSDE, peer to peer SQL Mobile to SQL Mobile replication, and some other options as well.

To give you some perspective on this issue, what SQL Express is lacking is more than just a set of server tools for SQL Mobile replication. There are some major, integral components missing from SQL Express which would be needed to support merge replication, including a SQL Agent, a Distribution Database and capability, Replication Monitor, and the ability to define publications and serve as a publisher to name a few. So given that, in my opinion, Microsoft is not likely to come out with a way to bolt all of that on to SQL Express as it exists today - it would effectively be the same as bringing SQL Express up to SQL Server 2005 Standard Edition.

So the real problem is there is no MSDE-equivalent that supports merge replication available with the 2005 set of dev tools. In my opinion (and this is only my opinion), Microsoft lost money on MSDE because an awful lot of people used it in pseudo production environments with 5 or fewer concurrent connections. So retiring it does encourage adoption of SQL Server 2005 standard or better edition, which is an improvement in revenue for the company.

I guess what I am saying is that I don't believe relief is coming in the next few days or weeks based on how large the effort would be to solve this problem (not just technically, but from a marketing, documentation, and distribution standpoint). So you are going to need to consider an alternate option while this issue is being addressed. Here are some options that other people are evaluating or have working now:

1. use web services and roll your own data sychronization between SQL Mobile and SQL Express (this would be my choice in your situation unless you have multiple mobile users changing the same data between synchronization events)

2. use SQL Server 2005 Standard Edition on the server if budget permits

3. use a third party synch tool - I just saw a note from someone at IntelliSync claiming that their Data Synch product has the ability to synchronize SQL Mobile to SQL Express. I have not personally tested that nor do I know what it costs, I'm just passing along that they have made the claim.

4. if your application has a "batch-mindset", meaning you populate a SQL Mobile Database, put it on device, work with it all day, and then copy it back to a server and extract the data, you can use a programmatic approach to synchronizing the data. Tools from www.primeworks.pt are excellent for this.

I will continue to emphasize to Microsoft in my internal discussions with them how important the issue is and if a solution becomes finalized, I'll communicate that here and in the public newsgroup.

-Darren

|||

Dear Darren

My sincere thanks for your detailed response. I think you should be running the development division at Microsoft because it is real shame and eye opener when an external consultant is answering these type of questions and we are being treated like fools by Microsoft employees who run you through the same time wasting exercise and questions

I thankyou for your answers and advice. But the question remains why arent we as customers getting these answers from a Microsoft person. Absolutely ridiculous

Regards

Touraj

|||

to be honest I think you are pretty much telling to good guys at Microsoft to do all the work for you - this is really not the way to go, nor will it ever happen. Microsoft has done HELL OF ALOT for developers and customers and yet they still get negitivity - outragous in my honest opinion.

putting the differences aside....

you should really handle this in "your" own way - in other words, your own mechinism. This is EASILY achieved. Use WebServices, this is what I had done on several projects of my own.

It doesnt take much time and you will be benefiting from improving your skills, using the technology more and can customize it the way you wish to - that's what it's all about.

my 10 cents ;-)