SQL Server Management Studio Express

Imar · August 6th, 2012, 04:33 AM

Hi there,

Good to hear it's working. Did you check out Appendix B? It shows you how to acquire, install and use Management Studio Express...

Cheers,

Imar

EDGY · August 7th, 2012, 11:50 AM

Yes, appendix B is very helpful, had win7 SP issues, I think.

Now that I have my databases in SQL Server; ? Use the SQL SERVER AUTHENTICATION method and the "RELEASE" version for going online/live testing via a Hosting service ?

And use WINDOWS AUTHENTICATION method for my development system now? This is the one that should work on my system? Practice/test combining the DBases(PlanetWrok & aspnetDB) this way ? (do this first ?)

And Now that i have SQL server, don't use \.SQLEXPRESS , except for early, easy simple development work ?

Thanks for your help, i'm totally new at this, book is great!! thanks Eddie

Imar · August 7th, 2012, 02:11 PM

Hi there,

Quote:

Now that I have my databases in SQL Server; ? Use the SQL SERVER AUTHENTICATION method and the "RELEASE" version for going online/live testing via a Hosting service ?

It depends ;-) If your host only supports SQL authentication, then yes. Otherwise, Windows authentication is preferred. Also, if they allow you to attach or restore database you can use the release version. Otherwise, you need to script it first as explained in the book.

Quote:

And use WINDOWS AUTHENTICATION method for my development system now? This is the one that should work on my system? Practice/test combining the DBases(PlanetWrok & aspnetDB) this way ? (do this first ?)

Yes, although I would still recommend using Express for this.

Quote:

And Now that i have SQL server, don't use \.SQLEXPRESS , except for early, easy simple development work ?

Same here. I would recommend using Express. It's not a toy system; it's a real database engine that just happens to be free. I use the Express engine for pretty much all my development although I do use the tools from the Developer edition.

Quote:

Thanks for your help, i'm totally new at this, book is great!! thanks Eddie

You're welcome.

Cheers,

Imar

EDGY · August 9th, 2012, 08:44 AM

Hey Imar,

I'm getting my dev/test system to use the SQL Server engine. I've got my Dbases loaded and my IIS points to my /Release folder but im getting remote connection errors. Im using the "recreating Dbase" connection settings from pg 726. I have 3 Instances running on SQL but no agents, do i need to stop the others and should 1 agent be up, im using one called MSSQLSERVER2.
i'm using SQL authentication. My page comes up when i call localhost, but get remote connection errors when calling any of the Dbase useage; Me Pipes provider is BAD ?

Your Assistance, suggestions and Guidance is greatly appreciated..
Thanks for your Help Imar,

Error Message
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

SQL Server 2008 R2 management studio
Win7

code:
<connectionStrings>

<clear />
<add name="PlanetWroxConnectionString1" connectionString="Data Source=EDWARD-PC/MSSQLSERVER2; Initial Catalog=PlanetWrox; User ID=PlanetWroxUser; password=Pa$$w0rD;" providerName="System.Data.SqlClient" />
<add name="PlanetWroxEntities" connectionString="metadata=res://*/App_Code.PlanetWrox.csdl|res://*/App_Code.PlanetWrox.ssdl|res://*/App_Code.PlanetWrox.msl;provider=System.Data.SqlCl ient; provider connection string="Data Source=EDWARD-PC/MSSQLSERVER2;Initial Catalog=PlanetWrox; User ID=PlanetWroxUser;password=Pa$$w0rD;MultipleActive ResultSets=True"" providerName="System.Data.EntityClient" />
<add name="LocalSqlServer" connectionString="Data Source=EDWARD-PC/MSSQLSERVER2; Initial Catalog=ASPNETDB; User ID=PlanetWroxUser;password=Pa$$w0rD" providerName="System.Data.SqlClient" />
</connectionStrings>

Imar · August 9th, 2012, 08:49 AM

Hi there,

Can you log in to SSMS directly? Also did you configure all connection strings in web.config to use this new provider? Can you post the code for that file?

Imar

EDGY · August 9th, 2012, 09:12 AM

I just now added the suspect code snippet to the orig message...Thanks for looking

Imar · August 9th, 2012, 09:22 AM

Have you tried EDWARD-PC\MSSQLSERVER2 instead of EDWARD-PC/MSSQLSERVER2? The correct way to address a named instance is with a back slash.

Cheers,

Imar

EDGY · August 9th, 2012, 09:22 AM

Imar,
Yea, i can get to SSMS directly, and i only get remote connection errors on my RELEASE version, because i just tested my VS/dev work ,and it got no remote connection errors, it has before, and all the functions/dbases are working properly there. So , it seems just my Release version thats having errors..

Thanks

EDGY · August 9th, 2012, 09:34 AM

DUDE,
your the Greatest. That was IT, I kept looking at that and did not see it.
Yes, the forward slash was wrong, changed it to backword slash, working GREAT.
As Dieter(mike miers/SNL) said, "Im as happy as a little girl!!"

Hwy, when working an issue like this , should i update my original message or always post new requests ?

Fantastic, Thanks Imar

on to the next step....true deployment...

Imar · August 9th, 2012, 09:38 AM

Glad to hear it's working.

I think posting a new message is best. I am subscribed to this forum so I get notifications by e-mail of new posts, and I am sure others here do that too. Updates to existing posts may go unnoticed as no mail is sent out.

Cheers,

Imar