Is there a notification icon?

Is there any way to configure a notification icon in the start tray in Express 2005 (like we had in SQL Server 2000) with a little green (or red) arrow (or dot) to indicate whether the server's up (or down)?

Hi,

SQL Service Manager doesn't come with SQL2005 editions, but if you want one, you can get it here.

Andrej

|||Cheers - that's gone straight into del.icio.us

Is there a good free database manager for SQL Server Express?

I saw this product called Toad and it looked like it was free but I was
unable to install it because it complained about expiring and stuff.
Thanks for your help.
Hi,
sure look here:
http://www.microsoft.com/downloads/d...6-1d4c98d40f6e
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de

Is the SP1 multilingual?

Hi,

Unlike the SQL Server 2005 SP1 download page, the SQL Server 2005 Express SP1 download page (http://msdn.microsoft.com/vstudio/express/sql/download/) and the pages it references don't mention whether the download is english only or multilingual. Since there's no language selection possibility on these pages, I'm assuming it's multilingual. Am I right?

Thanks in advance.

--
Patrick Philippot - Microsoft MVP
MainSoft Consulting Services
www.mainsoft.fr

Hi,

There is a dropdown to choose from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=11350b1f-8f44-4db6-b542-4a4b869c2ff1&DisplayLang=en

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks very much.

So there are pages where there's a selection dropdown and other pages for teh same download where no selection is possible. Strange.

--
Patrick

Is SqlServer Express good for desktop applications?

Do you believe that SqlServer Express can work absolutely without any administration?
That is to say: my clients are people without any technical knowledge and they usually communicate never with me.
Is SSE the correct database for this status, or should I use a desktop database like VFP or Access?

Once it's set up, it'll keep working indefinitely. You'll have to do most of the management in your software so the user can copy the database, for example.

The main limition with SQL Server Express is that you have to be sure to use an instance name that another applicaiton is unlikely to use, otherwise you'll have conflicts.

The main advantage of SQL Server Express versus something like Access is that you can easily move to the full-blown SQL Server Standard with virtually no effort.

-Ryan

|||

It's a better approach to determine the needs of your application, both now and in the future, and then choose the right database engine to meet those needs. One alternative that hasn't been mentioned yet is SQL Compact Edition, which is similar to Access/Jet in that it is a file based, in process database engine. (Compared to SQL Express which is a service based engine.)

There is a paper at http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx that attempts to clarify the differences between these platforms and why you would use one of the other. I generally think that you should start you planning at SQLce, since it offers a very light weight data engine that is easy to install and mange, and then work your way up the ladder if you discover application requriements that would prevent you from using it.

There is a forum dedicated to SQLce here on MSDN if you have questions about that database.

Mike

Is SQL Server Service Manager still existing on SQL Express Edition?

Hi there. I am new to the SQL Express. I just finished installing the SQL Express 2005 with Advanced Services on a Windows XP SP2 computer. The first thing I noticed was the service manager (used to be on the taskbar) was being removed on the Express Edition. How do I get this feature back if it's even possible? I know you can find out the server status from the Configuration Manager but it's handy if the status is showned on the taskbar after logging in.

Any help will be greatly appreciated. Thank you.

KC

There is no Service Manager in any SKU of SQL Server 2005. There are some folks out there that have written their own however.

Is SQL Server Express what I need?

Hello,

Someone I know told me that they thought SQL Server Express was what I am looking for. Before I get in over my head I need to know from people who use it if this is really for me.

I have build my own web site using very basic HTML and CSS. Nothing fancy I am very new to this.

What I want to do is have a customer able to enter their email address, once they have hit submit, I want the email address to go to a database (which I believe this software is going to help me set up?) and a document sent to them. I was thinking of a PDF attachment to an email since I have not figured out yet how to send an email that looks like a web page.

I now have a customer inquiry form on my site that is sent to a perl script in my cgi bin on my server. (The hosting company had to walk me through setting that up.) Will SQL Server Express work the same way?

I have no programming experience at all. Sorry for the bold but I need you to understand this. I need my answers in very plain concepts. Will I be able to use this software easily? It seems in the forum that there are alot of problems most of which I didn't understand the question or the answer.

I also have one website right now. I am planning on splitting it into three soon to pinpoint the market on each area better. Will I be able to use this software for more than one site?

I am using a PC running windows xp pro. I don't know any specifics for my hosting company's server.

Any information or help you can give to me would be greatly appreciated.

Robin

Hi Robin,

SQL Express is more than you need.

If all you need to store is an e-mail address, you should consider making things real simple and just using Excel or a text file. Unless you have a burning desire to learn how relational database systems work, the amount of time you invest in learning SQL Express would be very large compared to what you're actually trying to do.

You might want to consider hiring someone to do this work for you. It seems like you are trying to get something done for your business. Unless you're business involves creating web hosted databases, it would be a better investment to pay an expert who could do the job in a couple days than to spend weeks of your own time that could be better spend doing what you're an expert at. There are many companies who have reasonable rates to help you set up web sites for your business. Just a thought.

Mike

|||

Hi Mike,

At this point in time I want to gather emails and send an autoresponse to those people. I am a "print" graphic designer and am putting together my own site. At some point down the road I would like to build websites. I'm trying to gain this knowledge slowly as I put things into my site. As odd as it may sound, I thrive on learning anything computer related, I need to learn this for myself.

Before I dive into SQL Server Express I just want some educated advise to be sure this can help me. Down the road I want to add ecommerce and probably a search to my site and anything else that I realize as I build that I need. There are just so many programs and ways of doing things I just didn't want to download this and spend a few hours to find out that it isn't actually the type of program I needed.

Having someone do this for me is the easy way out. It also would make it so that I can't make changes anytime that I want to. I may end up asking a lot of questions but if this is for me than it is certainly worth my time to learn it.

Thank you for your time, I really appreciate it.

Robin

|||

HI,

I see that alot of people are viewing this post. Is there anyone out there that could answer my questions?

Thank you,

Robin

|||

Hi Robin,

SQL Express is still more than you need, but I applaud your willingness to learn.

The first thing to get straightened out is what SQL Express does. For you're purposes, SQL Express is just a database, it just stores stuff. All the various things you've mentioned you want to do, e.g. send e-mail, search, e-commerce, etc., are done using a combination of programs. You can use SQL Express to store e-mail addresses, keep customer information, store your catalog and keep track of orders that come in. All of the things that surround that, such as forms to forms for requesting information, pages showing the catalog, scripts to send e-mail, the shopping cart, etc are all implemented using a programming language. This type of functionality is not provided by SQL Express. If your web site is a car, SQL Express is the trunk.

If you're serious about learning all that functionality, I'd recommend you download Visual Web Developer Express, which is an entry level tool for building ASP.NET web sites. There is a bunch of content to help you learn how to use ASP.NET, and a number of pre-built projects, called Starter Kits, that help you learn how to make specific things. For example, there is an e-commerce Starter Kit. VWD and SQL Express can be integrated fairly easily so that the sites you build can store information in SQL Express.

Good luck and have fun.

Mike

|||

HI Mike,

Thank you for the info on Visual Web Developer Express, I was looking at that as an option. I am actually also looking at a hosting company that happens to have almost everything I want to do as part of their package. I just need to hook it all together. They are all setup to incorporate OScommerce and I have Access and they seem to have a great support team. As long as the support team is still great once I am signed up with them it seems that I'm on the right track.

Thank you so much for your time and help

Robin

|||

It's probably wise to go with a company that has all the "parts" pre-built for you. It gives you a chance to get things set up more quickly while still having some control over the design, and learning from the pre-built parts at the same time. Happy learning...

Mike

|||

Thank you,

Robin

Is SQL Server Express what I need?

Hello,

Someone I know told me that they thought SQL Server Express was what I am looking for. Before I get in over my head I need to know from people who use it if this is really for me.

I have build my own web site using very basic HTML and CSS. Nothing fancy I am very new to this.

What I want to do is have a customer able to enter their email address, once they have hit submit, I want the email address to go to a database (which I believe this software is going to help me set up?) and a document sent to them. I was thinking of a PDF attachment to an email since I have not figured out yet how to send an email that looks like a web page.

I now have a customer inquiry form on my site that is sent to a perl script in my cgi bin on my server. (The hosting company had to walk me through setting that up.) Will SQL Server Express work the same way?

I have no programming experience at all. Sorry for the bold but I need you to understand this. I need my answers in very plain concepts. Will I be able to use this software easily? It seems in the forum that there are alot of problems most of which I didn't understand the question or the answer.

I also have one website right now. I am planning on splitting it into three soon to pinpoint the market on each area better. Will I be able to use this software for more than one site?

I am using a PC running windows xp pro. I don't know any specifics for my hosting company's server.

Any information or help you can give to me would be greatly appreciated.

Robin

Hi Robin,

SQL Express is more than you need.

If all you need to store is an e-mail address, you should consider making things real simple and just using Excel or a text file. Unless you have a burning desire to learn how relational database systems work, the amount of time you invest in learning SQL Express would be very large compared to what you're actually trying to do.

You might want to consider hiring someone to do this work for you. It seems like you are trying to get something done for your business. Unless you're business involves creating web hosted databases, it would be a better investment to pay an expert who could do the job in a couple days than to spend weeks of your own time that could be better spend doing what you're an expert at. There are many companies who have reasonable rates to help you set up web sites for your business. Just a thought.

Mike

|||

Hi Mike,

At this point in time I want to gather emails and send an autoresponse to those people. I am a "print" graphic designer and am putting together my own site. At some point down the road I would like to build websites. I'm trying to gain this knowledge slowly as I put things into my site. As odd as it may sound, I thrive on learning anything computer related, I need to learn this for myself.

Before I dive into SQL Server Express I just want some educated advise to be sure this can help me. Down the road I want to add ecommerce and probably a search to my site and anything else that I realize as I build that I need. There are just so many programs and ways of doing things I just didn't want to download this and spend a few hours to find out that it isn't actually the type of program I needed.

Having someone do this for me is the easy way out. It also would make it so that I can't make changes anytime that I want to. I may end up asking a lot of questions but if this is for me than it is certainly worth my time to learn it.

Thank you for your time, I really appreciate it.

Robin

|||

HI,

I see that alot of people are viewing this post. Is there anyone out there that could answer my questions?

Thank you,

Robin

|||

Hi Robin,

SQL Express is still more than you need, but I applaud your willingness to learn.

The first thing to get straightened out is what SQL Express does. For you're purposes, SQL Express is just a database, it just stores stuff. All the various things you've mentioned you want to do, e.g. send e-mail, search, e-commerce, etc., are done using a combination of programs. You can use SQL Express to store e-mail addresses, keep customer information, store your catalog and keep track of orders that come in. All of the things that surround that, such as forms to forms for requesting information, pages showing the catalog, scripts to send e-mail, the shopping cart, etc are all implemented using a programming language. This type of functionality is not provided by SQL Express. If your web site is a car, SQL Express is the trunk.

If you're serious about learning all that functionality, I'd recommend you download Visual Web Developer Express, which is an entry level tool for building ASP.NET web sites. There is a bunch of content to help you learn how to use ASP.NET, and a number of pre-built projects, called Starter Kits, that help you learn how to make specific things. For example, there is an e-commerce Starter Kit. VWD and SQL Express can be integrated fairly easily so that the sites you build can store information in SQL Express.

Good luck and have fun.

Mike

|||

HI Mike,

Thank you for the info on Visual Web Developer Express, I was looking at that as an option. I am actually also looking at a hosting company that happens to have almost everything I want to do as part of their package. I just need to hook it all together. They are all setup to incorporate OScommerce and I have Access and they seem to have a great support team. As long as the support team is still great once I am signed up with them it seems that I'm on the right track.

Thank you so much for your time and help

Robin

|||

It's probably wise to go with a company that has all the "parts" pre-built for you. It gives you a chance to get things set up more quickly while still having some control over the design, and learning from the pre-built parts at the same time. Happy learning...

Mike

|||

Thank you,

Robin

Is SQL Server Express enough for me?

I'm trying to figure this one out. I'm currently on a shared SQL Server 2000 db. I'm almost at my limits in terms of size (300-500mb). I'm shrinking the log file constantly.

I plan on moving everything over to MySQL, but it's going to take time. I think I need a temporary solution, and I'm just not sure if SQL Server Express will be able do the trick.

Obviously, I'm under db size limit. I have no idea if the db running on 1gb ram and 1cpu is enough though, and I have no idea how to test outside of just chucking it up under real world conditions.

Anyone have any suggestions?500mb is nothing

good luck with mySQL..this site runs on it

Why are you so limited in space?|||I never wanted to run my own SQL Server, and getting some shared SQL Server space from my datacenter was a cost efficient way of doing things (plus, they handled backups, maintenance, etc).

However, my space has basically run out, my web server is starting to go (and I might be switching datacenters), and I don't think I can convert to MySQL so fast, so I'm hoping to just use Express for a few months. I realize space isn't an issue, but have zero clue about the ram/cpu limitations, or how Express runs when being used with a decently trafficked site.|||i haven't had the privilege of having a site that was that big, but wouldn't the obvious step be to move up from shared to dedicated at your same host?

that way you keep the same support team, backup procedures, etc.

if you run express, you'll be on your own as far as applying patches etc.

migrating to mysql is a definite option (the sql server guys in this forum are going to just say "shut up rudy" again, but mysql continues to blow the socks off legacy products as far as large web sites go)

however, you cannot just switch to mysql, there will be a lot more to the conversion than you think, and you are right not to do it "so fast"|||Have you considered Oracle Express, the entry-level database produced by the World's largest enterprise software company, and leading supplier of database software.|||robert, that conversion would be even costlier and longer term than the conversion to mysql

he has a high volume and very active live site

hardly entry-level|||Rudy,

I recommended Oracle based on the fact that it has superior functionality and performance with respect to concurrency, which I feel would be a key consideration for a high traffic website.

I do apologize if my comment may have been viewed as inappropriate in the context.

Regards,|||i haven't had the privilege of having a site that was that big, but wouldn't the obvious step be to move up from shared to dedicated at your same host?

that way you keep the same support team, backup procedures, etc.

if you run express, you'll be on your own as far as applying patches etc.

migrating to mysql is a definite option (the sql server guys in this forum are going to just say "shut up rudy" again, but mysql continues to blow the socks off legacy products as far as large web sites go)

however, you cannot just switch to mysql, there will be a lot more to the conversion than you think, and you are right not to do it "so fast"I'm definitely moving to mysql. It's just a matter of when. All I have are dedicated servers for my websites, but this one site needed a SQL Server db back then and I didn't need to have my own dedicated SQL Server db. For the amount of time I plan on having it stay on SQL Server, it'd probably still be a waste - plus, the moment I'm off their shared, I get none of the benefits, I'm just on my own no matter what.

I don't mind applying patches, doing backups, it's the "wtf is wrong now?" issue I don't want to run into - however, if Express will handle what I need, I might risk that for the cost of just having it on there for a month or so while I figure out my mysql transition.

The db itself is actually rather "basic". It's just standard data housing and a few simple stored procedures (at least imo). Porting to mysql shouldn't be too complex. I don't knoq mysql stored proc syntax (big issue), and then I just have to comb the site and look for errors so I can tweak any sql statements (should be minor, but could be tedious). Again, it's mostly just timing.
Have you considered Oracle Express, the entry-level database produced by the World's largest enterprise software company, and leading supplier of database software.Nope, I don't know a thing about managing an Oracle server.|||Have you considered Oracle Express, the entry-level database produced by the World's largest enterprise software company, and leading supplier of database software.

you funny

This message is too short|||Have you considered Oracle Express, the entry-level database produced by the World's largest enterprise software company, and leading supplier of database software.If you consider Oracle to be the only supplier of enterprise software, then I'll conceed that Oracle is the worlds largest supplier of Oracle software. If you look at the real world, there are more copies of both Microsoft and IBM products today in more companies around the world than Oracle could dream of publishing even if they gave their software away.

The same is true of Oracle database products

Neither of your points helps solve the problem of the original poster. Please stay on topic.

-PatP

Is SQL Server Express designed for production use?

Per the subject line :
Is SQL Server Express designed for production use?

hi Juan,

yes, it is.. are you experimenting inconveniences?

regards

|||

re:
> are you experimenting inconveniences?

None.

I was wondering, mainly, whether SQL Express differed from MSDE
...which wasn't designed for production use.

To further the question :

Express will only bind to one CPU at a time, and it cannot run queries in parallel.

Express cannot use more than 1 GB of RAM at a time for queries and data pages.
SQL Server 2005 will handle many more concurrent queries than the Express version.

No one database in Express can be larger than 4 GB.

Data mining, Data Transformation Services (DTS)
and reporting functions are not available for SQL Express.

Other functions not available in Express include clustering/mirroring,
full-text indexing/searching, SQLMail, indexed views, partitioned views and SQL Agent.

I.O.W., although it will work fine for small traffic websites,
I would have thought it isn't designed for heavy-duty production websites.

Maybe we need to distinguish between
"light traffic" and "heavy traffic" regarding SQL Express ?

Maybe I just have the wrong impression, and the limitations listed don't amount to much ?

|||

hi Juan,

Juan T. Llibre wrote:

re:
> are you experimenting inconveniences?

None.

I was wondering, mainly, whether SQL Express differed from MSDE
...which wasn't designed for production use.

actually MSDE was... it is "limited" compared to the full blown wditions of the relative product(s), but both MSDE and SQLExpress ARE ready for production..

you only have to see if they are "enought" to target your specific requirements, if the built-in limitations can be handled or have to be mandatory satisifed..

To further the question :

Express will only bind to one CPU at a time, and it cannot run queries in parallel.

Express cannot use more than 1 GB of RAM at a time for queries and data pages.
SQL Server 2005 will handle many more concurrent queries than the Express version.

No one database in Express can be larger than 4 GB.

Data mining, Data Transformation Services (DTS)

yep... that's true

and reporting functions are not available for SQL Express.

false ... the SQL Server Express Edition with Advanced Services provides (local server only) Reporting features as well

Other functions not available in Express include clustering/mirroring,

yep

full-text indexing/searching, indexed views, partitioned views

false, the very same edition with Advanced Services supports full text...

indexed views are "supported" as the engine will not throw exception, but the advanced optimizations on them will be not "used" by the optimizer...

SQLMail, and SQL Agent.

yep, but you can easely write a "kind of" replacement for Mail via simple SMTP CLR based procedure to send mail like my free and simple project, amDbobj ..

as regard SQL Agent, normal "stuffs" can be scheduled via native AT/SCHTASKS operating system scheduler, but, obviously, full blown jobs are often not completely transferrable to this kind of solution.. or you can write your own scheduler, like other devs already did

I.O.W., although it will work fine for small traffic websites,
I would have thought it isn't designed for heavy-duty production websites.

Maybe we need to distinguish between
"light traffic" and "heavy traffic" regarding SQL Express ?

Maybe I just have the wrong impression, and the limitations listed don't amount to much ?

it all dependes on the "final needs" and budget ..

I often am very satisfied with SQLExpress, but when the customer requires more "power", it's then very easy to just upgrade to the Standard edition..

regards

|||Thank you very much for your reply, Andrea.

I now have a clearer view.

Is SQL Server Express designed for production use ?

Per the subject line :

Is SQL Server Express designed for production use ?

As I know yes you can use it as databases for desktop application and is recomended to use as witness SQL server(because is free) in multiple SQL server environment.

see page below:

http://www.microsoft.com/sql/editions/express/default.mspx

Thanks

JPazgier

|||

Juan T. Llibre:

Per the subject line :

Is SQL Server Express designed for production use ?

Yes it is you can use it if you host your application Webform or Winform, the only thing not included with Express is the Agent so most SQL Server based automation you have to look for alternatives and there are many free solutions from SQL Server users. There is no Profiler but you can use the Developer edition profiler to profile your application. Try the link below for features compare in all editions. Hope this helps.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

Juan T. Llibre:

Per the subject line :

Is SQL Server Express designed for production use ?

For web applications in a shared hosting environment? No, not really.

|||

re:
>For web applications in a shared hosting environment? No, not really.

That's what I thought, but I was told by a 'softie that it is.
I'd like to have a definitive reason for this, whether it is, or not.

|||re:
> Yes it is you can use it if you host your application Webform or Winform,
> the only thing not included with Express is the Agent

To further the question :

Express will only bind to one CPU at a time, and it cannot run queries in parallel.

Express cannot use more than 1 GB of RAM at a time for queries and data pages.
SQL Server 2005 will handle many more concurrent queries than the Express version.

No one database in Express can be larger than 4 GB.

Data mining, Data Transformation Services (DTS)
and reporting functions are not available for SQL Express.

Other functions not available in Express include clustering/mirroring,
full-text indexing/searching, SQLMail, indexed views, partitioned views and SQL Agent.

I.O.W., although it will work fine for small traffic websites,
I would have thought it isn't designed for heavy-duty production websites.

Maybe we need to distinguish between
"light traffic" and "heavy traffic" regarding SQL Express ?

Maybe I just have the wrong impression, and the limitations listed don't amount to much ?|||

(Data mining, Data Transformation Services (DTS)
and reporting functions are not available for SQL Express.)

This is the calculus end it is not practical to expect it in a free edition and I would not run it even with the standard edition.

(Other functions not available in Express include clustering/mirroring,
full-text indexing/searching, SQLMail, indexed views, partitioned views and SQL Agent.)

Views are query rewrite edition is not relevant Partitioned Views are created with the UNION ALL SET operator and I don't think indexed views are affected either. Full text there is work around solution. Agent no and SQL mail is not there but the good SQL Server mail service is the Agent mail so you are not missing anything.

Parallel queries are seldom needed in OLTP(online transaction processing) and if you want all you have listed you need to host it in house with the Enterprise edition running on multi processor remember SQL Server license is per processor.

|||

Thanks, Caddre.

So, the next time I'm asked whether SQL Express is designed for production use, I should answer : yes ?

|||

Hi you are not exactly rights because in SQL Server Express SP 1 you have :

Microsoft SQL Server 2005 Express Edition Toolkit SP1
SQL Server Express Toolkit provides tools and resources to manage Microsoft SQL Server 2005 Express Edition, and to create reports by using SQL Server 2005 Reporting Services. The kit includes Connectivity Components, Business Intelligence Development Studio, Management Studio Express, and a Software Development Kit. To create reports by using Reporting Services, you must use Business Intelligence Development Studio.

Install Microsoft SQL Server 2005 Express Edition with Advanced Services(more...)

In addition to the features of SQL Server Express, certain additional capabilities are also available as part of Microsoft SQL Server 2005 Express Edition with Advanced Services (SQL Server Express). SQL Server Express with Advanced Services contains the following features:
SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases.
Reporting Services, an integrated report creation and design environment to create reports.
Full-Text Search, a powerful search engine for searching text-intensive data.

so you can do much more than in previous edition. check this page to see what you can get:

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

The only problem can be that Microsoft peoples say that SQL express is much slower than any other not free version of SQL Server, but based on my experience for small databases is not true, and I could not test for big because SQL express has a lot of size limits.

You can see all limitation of previous SQL Server express on page below, but SP1 remove some of this missing elements from the list:

http://msdn2.microsoft.com/en-us/library/ms165636.aspx

Thanks

JPazgier

|||

Juan T. Llibre:

Thanks, Caddre.

So, the next time I'm asked whether SQL Express is designed for production use, I should answer : yes ?

I am sorry I forgot to answer you yesterday, yes you can use Express to run small production site in house if you buy the Developer edition because you can use the Profiler and the database tuning advisor to improve performance your Express database.

Is SQL Server an option?

First off, I apologize for not knowing what I'm talking about and being long winded. I'm trying to determine if SQL Server Express is an option for a client of mine. Their needs are beginning to go beyond what I'm comfortable with in Access, so I'm looking into the option of upgrading to a SQL Server Express back-end with a VB front-end.

Access doesn't require any setup beyond "File, new", so I know nothing about the background work required to get a database running on a platform like SQL Server.

My first concern is what kind of network admin rights do I need to install & use SSE..

It's unlikely that her IT group will just hand us the keys to any of their servers, so all we really have available is what we can put on her network drives. Am I right in assuming that using a SQL Server database would involve more network privileges than just dropping a file on the network and pointing my front end app at it?

With that said, I think I remember seeing something on one of the MSDN pages about setting up a database to run off of a CD-Rom. Could I somehow use this capability to get what I need?SQL Server really insists on having the database sit on a local drive... It isn't at all happy about using network drive space.

You don't technically need anthing more than machine administrator privleges to install SQL 2005 Express, and once the service is installed it can actually run as "local system" as one of the choices, making it very comparable to MS Access. SQL Server provides many other choices, but this is pretty comparable to what you're accustomed to with Jet (the database engine used by MS-Access).

You need to invest some time up front to learn about SQL Server Express. It offers so many choices that go far beyond what Jet allows. While it takes more time up front, the additional choices are definitely worth the effort in my opinion!

-PatP|||You can't just point your app to read a SQL server MDF file off a network drive - SQL Server works as a service and needs to be installed on a PC somewhere on the network. Clients don't read the mdf/ldf files - SQL Server does this on behalf of the clients.
Note: SQL Server Express introduces an xcopy deployment concept where you can automatically connect an mdf file to a running instance of SQL Server Express and detach the database when your app is finished with it. This makes MDF files portable; similar to access database files (providing users have SQL Express installed on their machines). If your scenario requires users accessing a central database, this is unsuitable – besides, additional time is required to attach the database every time you run you app and all the clients would require SQL Express (each having a local copy of the database)

Installing SQL Server isn’t too difficult – SQL Express is easier to install than its predecessor, MSDE (which required command line options to set the sa password – at least in the earlier versions). Installing SQL Express is about as easy as installing any other program such as MS Office. The defaults are probably ok for most installations, but its worth while learning how they affect your server – things such as the collation settings.

There are various ways for you to actually deploy you database to the server once SQL Server Express is installed – if you don’t want to go to the lengths of creating an installer, you could simply supply the database files and instructions on how to attach the database to the server. A set of instructions on a single side of A4 should be sufficient – A computer savvy person shouldn’t have any problems setting up SQL Express and attaching the database without need for your involvement.

As for your front end apps – a connection string is required to specify the server, the database and authentication details (similar to a connection string specifying the path of the Access database file). Store this string in a config file (text/xml file) that can be modified without re-compiling your application.

There are various options for upgrading Access databases to SQL Server. I believe the easiest option is to use the upsizing wizard – this can also upgrade your front end to an Access project that connects to the new SQL database. Play about with the upsizing wizard and perform thorough testing – it’s unlikely to get everything right. Check that the SQL data types it selects for your columns are the most appropriate type. Check indexes and constraints are created correctly.

As Pat said above – take some time to learn SQL Server Express. Microsoft has certainly made the new version of SQL Server Express accessible to developers – many are now opting to use SQL Server over MS Access. Access databases are still appropriate for smaller projects and it remains a great client tool.|||You can't just point your app to read a SQL server MDF file off a network drive - SQL Server works as a service and needs to be installed on a PC somewhere on the network. Clients don't read the mdf/ldf files - SQL Server does this on behalf of the clients.
Right.. That's what I gathered from "Figure 2" on this page: http://www.informit.com/articles/article.asp?p=26863&seqNum=1

So I gather that I have to have a dedicated machine that's always on (i.e. a server) that has SQL Server (or SSE in my case) installed and running. My apps (installed on each user's machine) contain connection protocol that connect to the server, which sends data back & forth as needed..

I assume that it's not a good idea to have one of my user's machines operating as the server. It seems like to use SQL Server, I'd have to get my my client to spring for a dedicated box OR get her IT department to use one of their existing servers, correct?

I'd really like to learn and use SSE for this because they're also talking about combining the two apps that I've built into one. I'd be really, really worried about Access handling that.

I'll take some time later and re-read these two replies & see if I can come up with any other questions..

Thanks again for your help!|||Yes - thats about right. You could use one of the clients as the server - for a small workgroup environment this is probably ok, but ideally you want this on a server computer that isn't going to get shut down. It's better to run SQL Server on a dedicated server, but this might be overkill for your scenario.|||As far as upgrading an existing Access front-end to use sql server...

Good Luck

Have never seen one that didn't need to be re-written|||As far as upgrading an existing Access front-end to use sql server...

Good Luck

Have never seen one that didn't need to be re-written
Actually I did one a few years ago that worked out pretty well. I was in a department that had a drawing check-out/check-in/search system.

Since I knew the process extremely well, I designed the new app from the ground up in Access 97. We used it for about a month to feel it out & make sure the data structure really was what we wanted. After that, we handed it off to a guy in the IT group who replicated the data structure in SQL Server 2000.

When he was done, we ported the data over and went online with the new front end/back end setup. There were a few quirks to work out over the next week or so, but nothing major and definitely not a full re-write.

Back to the original topic - I'm going to have a good heart to heart with her about my concerns and our options going forward. This isn't mission critical, 100%-uptime data, but I'd rather not set it up on a user machine.

Ideally, we'll be able to find an ally in IT that will set up SSE for us. Next best solution would be buying a low-end box specifically set up to act as a server and stashing it in her area. (They have a purchasing agreement with Dell. Any reason their low-end Celerons wouldn't be suitable?)

Thanks for working through this with me guys..

Is SQL Server 2005 Express the new version of MSDE?

Hi,
Is SQL Server 2005 Express the new version of MSDE once it's final? I assume
it will have similar restrictions -- 10 connections, etc.
Thanks,
Sam
Yes, SQL Server 2005 is the successor to MSDE. It will still be free, it
will still be distributable, and licensing (so I hear) will be /much/
simpler.
No, there will not be a 10 connection restriction, and there never was in
MSDE, either. There was a workload governor that kicked in when you go over
8 simultaneous (5 user/3 system) *workloads*, which are not the same as
connections. Please read
http://msdn.microsoft.com/library/en...r_sa2_0ciq.asp
There is no such governor/throttle technology in SQL Server 2005 Express.
As for other differences between MSDE 2000 and SQL Server 2005 Express:
SQL Server 2005 Express will add a currently not available graphical
management tool, called Express Manager (its features will be a subset of
those found in Management Studio). Maximum database size has been increased
from 2 GB to 4 GB (and still does not count log space toward the limit).
SQL Server 2005 Express is now limited to 1 GB RAM and 1 CPU (MSDE allowed 2
GB RAM and 2 CPUs). SQL Server Agent and DTS runtime are no longer
included, and there is limited replication support. Currently, SQL Server
2005 Express is only supported on 2000, XP, and 2003. I don't believe the
consumer 9x line (95, 98, Me) will be supported.
If I missed anything, I'm sure someone will swoop in and clean up. You can
also see:
http://msdn.microsoft.com/library/en...seoverview.asp
http://www.aspfaq.com/
(Reverse address to reply.)

> Is SQL Server 2005 Express the new version of MSDE once it's final? I
assume
> it will have similar restrictions -- 10 connections, etc.
|||Sam,
Bascially the answer is yes, but the restrictions are different. SQL Express
uses limitation of database size and number of processors used but does not
use the workload governor.
Ginny Caughey
..Net Compact Framework MVP
"Sam" <sam@.globalwebcentral.com> wrote in message
news:euGLloeiEHA.1040@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Is SQL Server 2005 Express the new version of MSDE once it's final? I
assume
> it will have similar restrictions -- 10 connections, etc.
> Thanks,
> Sam
>

Is SQL Server 2005 Express Edition with Advanced Services FREE ?

I can't find any information on this. Thanks.

Yep, it's free.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

is SQL Reporting Services available for the Express Editions ?

Hello,

is SQL Reporting Services available for the Express Editions ? How can I create reports for my VB Express Application?

Desperate...

You need to download the "SQL Server 2005 Express Edition with Advanced Services SP1". This edition contains the Reporting Services.

http://msdn.microsoft.com/vstudio/express/sql/download/

Is SQL Express required...

Does SQL Express 2005 have to be installed for SQL Developer 2005 to work correctly in VB 2005 Pro?

Thank you,

David

Nope, SQL Express and SQL Developer are just two different editions of SQL Server 2005. You can have either one for your VB install to connect to.

Thanks,

Sam Lester (MSFT)

Is SQL Express 2005 by default a single connection db?

Is SQL Express 2005 by default a single connection db?
Background:
I wrote a simple .bat file which executes the following sqlcmd call:
"sqlcmd -S BLUEBOX\SQLEXPRESS -d C:\App_Data\ASPNETDB.MDF -U
MyUserCount -P MyUserPassword -Q "Exec SendMessage" -o C:\Vocalico
\SendMailQuePump\Undelievered.txt"
the above command works fine, as long as no other application is
accessing the db.
Also, using VS2005 I wrote a simple web based calendar scheduling
application which I am testing by launching it via Visual Studio 2005
(using the built in ASP.Net Development Server), the web application
seems to work correctly as well.
The Problem Found:
When I run the VS2005 web application the sqlcmd fails to login (note
that the web application and the sqlcmd access the same db (C:\App_Data
\ASPNETDB.MDF)). The following is the error I get form SQL 2005
Express when running the sqlcmd while the web application is running:
Msg 5120, Level 16, State 101, Server BLUEBOX\SQLEXPRESS, Line 1
Unable to open the physical file "C:\App_Data\aspnetdb.mdf". Operating
system error 32: "32(The process cannot access the file because it is
being used by another process.)".
Msg 5120, Level 16, State 101, Server BLUEBOX\SQLEXPRESS, Line 1
Unable to open the physical file "C:\App_Data\aspnetdb_log.ldf".
Operating system error 32: "32(The process cannot access the file
because it is being used by another process.)".
File activation failure. The physical file name "C:\App_Data
\aspnetdb_log.ldf" may be incorrect.
Msg 4060, Level 11, State 1, Server BLUEBOX\SQLEXPRESS, Line 1
Cannot open database "C:\App_Data\ASPNETDB.MDF" requested by the
login. The login failed.
Msg 18456, Level 14, State 1, Server BLUEBOX\SQLEXPRESS, Line 1
Login failed for user 'MyUserCount'.
Questions:
Shouldn't SQL 2005 Express allow more than one user to connect and
authenticate to the db by default? Are there any settings I need to
modify in Visual Studio 2005 or SQL Express 2005 in order to allow my
web app and the sqlcmd command to co-exist and execute without
interfering with each other?
My Setup:
VS 2005
XP Professional SP2
SQL 2005 Express
web.config connection string looks like this:
<add name="ASPNETDBConnectionString" connectionString="Data Source=.
\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated
Security=SSPI;User Instance=True" providerName="System.Data.SqlClient"/
>
I have been going around in circles on this issue, any help would be
greatly appreciated!
Sincerely,
-ralphI think there might be some confusion to what the database concept is. For the "real" SQL server, we
create the database and to use it, se specify the database name in the USE command, or the database
name in the connection string or for the -d option for sqlcmd. But you use the physical name of the
mdf file in your sqlcmd call.
My guess is that sqlcmd does either some form of special attach (read about sp_attach_db for the
concept of attach) and it becomes in some form of single user mode. Or that sqlcmd even handles the
instance as a user-instance (a concept only available for Express, which I haven't played with but
which you should be able to find some info if you Google).
So, what I would do is to attach the database (sp_attach_db) and then specify the database name (not
file name) in sqlcmd and your connection string.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"RGF" <Raf.Figueroa@.gmail.com> wrote in message
news:dcdeef9a-382d-47dd-9829-b491eb48df6a@.e4g2000hsg.googlegroups.com...
> Is SQL Express 2005 by default a single connection db?
> Background:
> I wrote a simple .bat file which executes the following sqlcmd call:
> "sqlcmd -S BLUEBOX\SQLEXPRESS -d C:\App_Data\ASPNETDB.MDF -U
> MyUserCount -P MyUserPassword -Q "Exec SendMessage" -o C:\Vocalico
> \SendMailQuePump\Undelievered.txt"
> the above command works fine, as long as no other application is
> accessing the db.
> Also, using VS2005 I wrote a simple web based calendar scheduling
> application which I am testing by launching it via Visual Studio 2005
> (using the built in ASP.Net Development Server), the web application
> seems to work correctly as well.
> The Problem Found:
> When I run the VS2005 web application the sqlcmd fails to login (note
> that the web application and the sqlcmd access the same db (C:\App_Data
> \ASPNETDB.MDF)). The following is the error I get form SQL 2005
> Express when running the sqlcmd while the web application is running:
> Msg 5120, Level 16, State 101, Server BLUEBOX\SQLEXPRESS, Line 1
> Unable to open the physical file "C:\App_Data\aspnetdb.mdf". Operating
> system error 32: "32(The process cannot access the file because it is
> being used by another process.)".
> Msg 5120, Level 16, State 101, Server BLUEBOX\SQLEXPRESS, Line 1
> Unable to open the physical file "C:\App_Data\aspnetdb_log.ldf".
> Operating system error 32: "32(The process cannot access the file
> because it is being used by another process.)".
> File activation failure. The physical file name "C:\App_Data
> \aspnetdb_log.ldf" may be incorrect.
> Msg 4060, Level 11, State 1, Server BLUEBOX\SQLEXPRESS, Line 1
> Cannot open database "C:\App_Data\ASPNETDB.MDF" requested by the
> login. The login failed.
> Msg 18456, Level 14, State 1, Server BLUEBOX\SQLEXPRESS, Line 1
> Login failed for user 'MyUserCount'.
> Questions:
> Shouldn't SQL 2005 Express allow more than one user to connect and
> authenticate to the db by default? Are there any settings I need to
> modify in Visual Studio 2005 or SQL Express 2005 in order to allow my
> web app and the sqlcmd command to co-exist and execute without
> interfering with each other?
> My Setup:
> VS 2005
> XP Professional SP2
> SQL 2005 Express
> web.config connection string looks like this:
> <add name="ASPNETDBConnectionString" connectionString="Data Source=.
> \SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated
> Security=SSPI;User Instance=True" providerName="System.Data.SqlClient"/
> I have been going around in circles on this issue, any help would be
> greatly appreciated!
> Sincerely,
> -ralph
>
>
>

Is SQL Express 2005 by default a single connection db?

Is SQL Express 2005 by default a single connection db?
Background:
I wrote a simple .bat file which executes the following sqlcmd call:
"sqlcmd -S BLUEBOX\SQLEXPRESS -d C:\App_Data\ASPNETDB.MDF -U
MyUserCount -P MyUserPassword -Q "Exec SendMessage" -o C:\Vocalico
\SendMailQuePump\Undelievered.txt"
the above command works fine, as long as no other application is
accessing the db.
Also, using VS2005 I wrote a simple web based calendar scheduling
application which I am testing by launching it via Visual Studio 2005
(using the built in ASP.Net Development Server), the web application
seems to work correctly as well.
The Problem Found:
When I run the VS2005 web application the sqlcmd fails to login (note
that the web application and the sqlcmd access the same db (C:\App_Data
\ASPNETDB.MDF)). The following is the error I get form SQL 2005
Express when running the sqlcmd while the web application is running:
Msg 5120, Level 16, State 101, Server BLUEBOX\SQLEXPRESS, Line 1
Unable to open the physical file "C:\App_Data\aspnetdb.mdf". Operating
system error 32: "32(The process cannot access the file because it is
being used by another process.)".
Msg 5120, Level 16, State 101, Server BLUEBOX\SQLEXPRESS, Line 1
Unable to open the physical file "C:\App_Data\aspnetdb_log.ldf".
Operating system error 32: "32(The process cannot access the file
because it is being used by another process.)".
File activation failure. The physical file name "C:\App_Data
\aspnetdb_log.ldf" may be incorrect.
Msg 4060, Level 11, State 1, Server BLUEBOX\SQLEXPRESS, Line 1
Cannot open database "C:\App_Data\ASPNETDB.MDF" requested by the
login. The login failed.
Msg 18456, Level 14, State 1, Server BLUEBOX\SQLEXPRESS, Line 1
Login failed for user 'MyUserCount'.
Questions:
Shouldn't SQL 2005 Express allow more than one user to connect and
authenticate to the db by default? Are there any settings I need to
modify in Visual Studio 2005 or SQL Express 2005 in order to allow my
web app and the sqlcmd command to co-exist and execute without
interfering with each other?
My Setup:
VS 2005
XP Professional SP2
SQL 2005 Express
web.config connection string looks like this:
<add name="ASPNETDBConnectionString" connectionString="Data Source=.
\SQLEXPRESS;AttachDbFilename=|DataDirect
ory|\ASPNETDB.MDF;Integrated
Security=SSPI;User Instance=True" providerName="System.Data.SqlClient"/
>
I have been going around in circles on this issue, any help would be
greatly appreciated!
Sincerely,
-ralphI think there might be some confusion to what the database concept is. For t
he "real" SQL server, we
create the database and to use it, se specify the database name in the USE c
ommand, or the database
name in the connection string or for the -d option for sqlcmd. But you use t
he physical name of the
mdf file in your sqlcmd call.
My guess is that sqlcmd does either some form of special attach (read about
sp_attach_db for the
concept of attach) and it becomes in some form of single user mode. Or that
sqlcmd even handles the
instance as a user-instance (a concept only available for Express, which I h
aven't played with but
which you should be able to find some info if you Google).
So, what I would do is to attach the database (sp_attach_db) and then specif
y the database name (not
file name) in sqlcmd and your connection string.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"RGF" <Raf.Figueroa@.gmail.com> wrote in message
news:dcdeef9a-382d-47dd-9829-b491eb48df6a@.e4g2000hsg.googlegroups.com...
> Is SQL Express 2005 by default a single connection db?
> Background:
> I wrote a simple .bat file which executes the following sqlcmd call:
> "sqlcmd -S BLUEBOX\SQLEXPRESS -d C:\App_Data\ASPNETDB.MDF -U
> MyUserCount -P MyUserPassword -Q "Exec SendMessage" -o C:\Vocalico
> \SendMailQuePump\Undelievered.txt"
> the above command works fine, as long as no other application is
> accessing the db.
> Also, using VS2005 I wrote a simple web based calendar scheduling
> application which I am testing by launching it via Visual Studio 2005
> (using the built in ASP.Net Development Server), the web application
> seems to work correctly as well.
> The Problem Found:
> When I run the VS2005 web application the sqlcmd fails to login (note
> that the web application and the sqlcmd access the same db (C:\App_Data
> \ASPNETDB.MDF)). The following is the error I get form SQL 2005
> Express when running the sqlcmd while the web application is running:
> Msg 5120, Level 16, State 101, Server BLUEBOX\SQLEXPRESS, Line 1
> Unable to open the physical file "C:\App_Data\aspnetdb.mdf". Operating
> system error 32: "32(The process cannot access the file because it is
> being used by another process.)".
> Msg 5120, Level 16, State 101, Server BLUEBOX\SQLEXPRESS, Line 1
> Unable to open the physical file "C:\App_Data\aspnetdb_log.ldf".
> Operating system error 32: "32(The process cannot access the file
> because it is being used by another process.)".
> File activation failure. The physical file name "C:\App_Data
> \aspnetdb_log.ldf" may be incorrect.
> Msg 4060, Level 11, State 1, Server BLUEBOX\SQLEXPRESS, Line 1
> Cannot open database "C:\App_Data\ASPNETDB.MDF" requested by the
> login. The login failed.
> Msg 18456, Level 14, State 1, Server BLUEBOX\SQLEXPRESS, Line 1
> Login failed for user 'MyUserCount'.
> Questions:
> Shouldn't SQL 2005 Express allow more than one user to connect and
> authenticate to the db by default? Are there any settings I need to
> modify in Visual Studio 2005 or SQL Express 2005 in order to allow my
> web app and the sqlcmd command to co-exist and execute without
> interfering with each other?
> My Setup:
> VS 2005
> XP Professional SP2
> SQL 2005 Express
> web.config connection string looks like this:
> <add name="ASPNETDBConnectionString" connectionString="Data Source=.
> \SQLEXPRESS;AttachDbFilename=|DataDirect
ory|\ASPNETDB.MDF;Integrated
> Security=SSPI;User Instance=True" providerName="System.Data.SqlClient"/
> I have been going around in circles on this issue, any help would be
> greatly appreciated!
> Sincerely,
> -ralph
>
>
>

Is SQL 2005 Express compatible with WSUS?

Is SQL 2005 Express compatible with WSUS?
What do you mean by compatible?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Jef" <Jef@.discussions.microsoft.com> wrote in message
news:4B6D9F61-5B8B-4E27-8E41-B061E384210A@.microsoft.com...
> Is SQL 2005 Express compatible with WSUS?
|||WSUS requires SQL 2000 Desktop Engine, SQL Server 2000, or MSDE 2000 sp3 for
it's database. I was wondering if I could use SQL 2005 Express Edition
instead.
"Roger Wolter[MSFT]" wrote:

> What do you mean by compatible?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Jef" <Jef@.discussions.microsoft.com> wrote in message
> news:4B6D9F61-5B8B-4E27-8E41-B061E384210A@.microsoft.com...
>
>
|||I guess that's something you will have to ask the WSUS folks. I would
assume they haven't tested in SQL Express yet so it's probably not a safe
thing to do. I talked to them about using Yukon in their next release but
I don't know if they plan to test with their current release.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Jef" <Jef@.discussions.microsoft.com> wrote in message
news:6094FC34-3FE0-4B08-B025-689D1699B1C0@.microsoft.com...[vbcol=seagreen]
> WSUS requires SQL 2000 Desktop Engine, SQL Server 2000, or MSDE 2000 sp3
> for
> it's database. I was wondering if I could use SQL 2005 Express Edition
> instead.
> "Roger Wolter[MSFT]" wrote:

Is Point in time recovery the same in all versions of SQL Server 2005?

Hello everyone,

Our company will be using SQL Server 2005 Enterprise on our main server and either SQL Server Express or workgroup for our disconnected users. Our users will be syncing their local database with the main server using replication.

The question that was brought up is about the PIT recovery in SQL Server Express and workgroup. Please correct me if I am wrong. From what I understood, Point in time recovery is the same in both the Express and the WG editions. The database restores the full backup then incremental backups (if any) then the transactional logs. The only exception is that WG edition supports log shipping. Am I right?

I also watch one of the sql server 2005 webcasts series that talked about the online piecemeal recovery. From my understanding, online restore feature is an enterprise edition feature which allows the server to restore backup and logs, server goes online then roll back uncommited transactions. My question is if we are to use Express or WG, can we restore filegroups or pages (offline)? In another word, can we restore specific tables to point in time instead of the whole database.

Thanks a lot.

Point in time recovery is the same in all versions of sql2005.

Minor point: we do not support incremental backup. I'm sure you are refering to differential backups.

As far as I know, log shipping is only supported by the enterprise edition. That refers to our automatic tools to setup and maintain the log shipping.

The underlying engine supports log shipping in all versions, but you'd have to "roll your own" automated procedures.

Regarding piecemeal restore: we only support online restore in the enterprise edition. File/fileGroup/Page restore is offline in all other editions.

It is not possible to restore filegroups (and the tables they contain) to different points in time. The only way to perform a table restore:

- perform a partial restore to a working database. Just restore the filegroups containing the tables of interest.

- then export the tables (or sets of rows) of interest and merge them back into your online database. It is possible that referential integrity constraints will require more work than just inserting the rows of interest (you may have to delete/update other tables to maintain consistency).

Hope that helps.

Is only "shared memory" connection with "SQL Server Management Studio Express&quo

I have installed MS SQL Sever Express with it there is a SQL Server Configuration Manager installed. In this configuration manager there it is possible to enable and disable protocols for SQLEXPRESS. The following protocols are supported (and each protocol can be enabled/disabled individually):

Shared memory, Named Pipes, TCP/IP and VIA.

In the "SQL Server Management Studio Express" I connect to the SQL server and this works fine when "shared memory" are enabled. But when I disable "shared memory" in the configuration manager I can not connect to the SQL server via "SQL Server Management Studio Express".

In the "SQL Server Management Studio Express" there also are some "options/connection properties". There is a property for "network protocol" nomally set to "default" but possible to change to any of the enabled protocols. I have tested both to match the enabled protocols and also using the "default" selection without any success as long as "shared memory" is disabled in the configuration manager!

So, is it possible to enable only TCP/IP (or only named pipes) in the configuration manager and connecting to the SQL Server from the "SQL Server Management Studio Express"?

I'm going to move this to the Tools forum.

- Mike

|||

When connecting to a local server management studio uses shared memory. The other connection types are only used when establishing connections to remote servers.

Cheers,
Dan