Is there a sql database function to check connection string?

Im working on a db library and I have everything working, what Im wanting to do is though is add a method that can check a connection string to make sure it is actually working. Right now, I have it doing a simple select * query to a particular table and returning true or false if an exception is caused. But I want to make the library as generic as possible, so is there another way to test teh connection string and tell if its working or not?
Thanks,
CedricHmm. Well you could try something like SELECT GETDATE() or SELECT @.@.VERSION, which are not database schema-specific.

Is there a quick and easy way of getting a connection string for my app

I'm wondering if theres some easy/simple way of getting what would be the connection string if say I was using visual studio? I'm just tired of having to fiddle with a db connection string because i've missed a letter or a comma.why dont you store the connection string in the web.config file...so you dont have to worry abt it...also its more flexible..even if you change your db...you only need to change it at one place..

hth|||yeah, thats what I always do. But my job requires me to create a lot of new apps and I just need to know if theirs some quick way of ascertaining the connection details for one of those new apps.|||You can invoke the OLEDB Connection wizard and get the string from the that. Not really automatic but it gives you all the necessary details.|||where do i do that? thanks again!!|||The dialog is the same one you get when use a OLEDbConnection object. However, I've just had a look for how you invoke that from .net and can't find a managed version or wrapper. So unless someone else can provide you with that you'd have to make a p/invoke to the old API or maybe a COM interface. Sorry :(

Is there a possibility to be hacked

We have connection with sql server 2000 with front end visual foxpro 9 in
which we gave rights to user and install front end exe in client computer is
there any possibility that outsider can hack our server. how it possiblity
pls tellTHere is *ALWAYS* a possibilitiy that you can be hacked.
with vfp - you should do some encrypting/branding of your code; a guy named
Leonid has made a pretty good tool that he has indicated might be freeware w
hen
he releases.
Anyway -- the code can be dcompiled & someone can see your connection string
.
someone can packet sniff & watch teh data going back & forth.
There are exploits for sql2000 to gain access
If your firewall is up to date, and by "outsider" you mean not on your local
network; the chances are probably fairly low.
On Wed, 25 Jan 2006 17:51:49 +0530, "Dinesh" <dinesh_pl2001@.yahoo.co.in> wro
te:

>We have connection with sql server 2000 with front end visual foxpro 9 in
>which we gave rights to user and install front end exe in client computer i
s
>there any possibility that outsider can hack our server. how it possiblity
>pls tell
>
-- AntiSpam/harvest --
Remove X's to send email to me.|||can u tell the path of that pretty good tool that he has indicated might be
freeware when he releases.
"Josh Assing" <XjoshX@.jAssing.com> wrote in message
news:ee7ft1pa94b01kbmd3o207c5if8nqqc0fi@.
4ax.com...
> THere is *ALWAYS* a possibilitiy that you can be hacked.
> with vfp - you should do some encrypting/branding of your code; a guy
named
> Leonid has made a pretty good tool that he has indicated might be freeware
when
> he releases.
> Anyway -- the code can be dcompiled & someone can see your connection
string.
> someone can packet sniff & watch teh data going back & forth.
> There are exploits for sql2000 to gain access
> If your firewall is up to date, and by "outsider" you mean not on your
local
> network; the chances are probably fairly low.
> On Wed, 25 Jan 2006 17:51:49 +0530, "Dinesh" <dinesh_pl2001@.yahoo.co.in>
wrote:
>
is[vbcol=seagreen]
possiblity[vbcol=seagreen]
>
> -- AntiSpam/harvest --
> Remove X's to send email to me.

Is the connection string for SQL Server and MSDE the same?

The connection string I'm currently using for SQL Server is Provider=SQLOLEDB;Server=SERVER\VSDOTNET;Database= CCDDbase;Integrated Security=SSPI

would this be the same query string for MSDE database? I'm quite new in MSDE but I know that except for the tools that comes with SQL Server and its size, they are practically the same...You'll obviously have to change the variable parts of your connection string like the server and database names, but other than that you are "good to go" using the same connection string.

-PatP|||Here's a nice little URL for your favorites:

http://www.connectionstrings.com/

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 replication without network connection but file-based possible?

Hello,

I've been looking around in several SQL-Forums and in SQL Books Online but haven't found clear suggestions how to tackle my problem:

Our company has to fill a database with documentation for our contractor. Our subcontractors have to supply information from their branch/craft into this database, too.

Replication (without determining a type at this time) would do fine for data-exchange between us and our subcontractors.

But for working in different companies the networks are not connected
and in some companies/departments connection to the Internet is prohibited at all.
This would result in data-exchange based on files - which wont be a problem as data needs to be updated/exchanged only once a week and is usually done at meetings using DVD-Rs.

scenario in short:
- two-way exchange of data between SQL servers being not connected
- update needed once a week
- our server: SQL Server 2005 Standard (preferred)
- servers of our subcontractors: SQL Server Express 2005 (preferred)

That's the point where I dont know how to proceed:
Is two-way replication based on files possible at all?

I read about Snapshots, but to my understanding this replaces the "whole database" without caring about changes made to it and that's why it wont work for two-way exchange.

I would appreciate your hints how to solve this problem in general or whether I should look out for other solutions - MS Access might work with restrictions - but I would prefer SQL Server.

Thanks for reading until here and in advance for your answers.

Regards,

Michael__H

Hi Michael.

I do not think there is an easy solution for your problem. There is no offline file based replication solution that will also do 2-way replication for you.

The closest you can get by is backup restore but that will overwrite your data on the other side.

However if you have even Internet connection, then you will be able to solve your problem by using Web Synchronization which is a new feature in SQL Server Merge replication for SQL Server 2005.

|||

Hello Mahesh,

thank you for your answer.

According to your reply I'm going to solve my problem by using stored procedures writing my own little "replication":

- select records to be altered by our subcontractors
- mark them in separate column as 'currently exported'
- copy to external database/file X
- let our subcontractors complete missing data in database/file X
- compare returned database/file X with records in database marked as 'currently exported'
- import changed records

Of course it won't be easy but as far as no other solution is possible...

Michael

|||

Michael,

Your solution will work but it could be tricky.

Again I encourage you to take a look at Web Synchronization if you remotely think that the subscribers could have atleast internet connection.

|||

Hello Mahesh,

I'll have a closer look at Web-Synchronization , it seems to be a solution. And if not, my "replication" will be used.

Your suggestion has given my a direction for further reading, thank you.

Michael

Is replication without network connection but file-based possible?

Hello,

I've been looking around in several SQL-Forums and in SQL Books Online but haven't found clear suggestions how to tackle my problem:

Our company has to fill a database with documentation for our contractor. Our subcontractors have to supply information from their branch/craft into this database, too.

Replication (without determining a type at this time) would do fine for data-exchange between us and our subcontractors.

But for working in different companies the networks are not connected
and in some companies/departments connection to the Internet is prohibited at all.
This would result in data-exchange based on files - which wont be a problem as data needs to be updated/exchanged only once a week and is usually done at meetings using DVD-Rs.

scenario in short:
- two-way exchange of data between SQL servers being not connected
- update needed once a week
- our server: SQL Server 2005 Standard (preferred)
- servers of our subcontractors: SQL Server Express 2005 (preferred)

That's the point where I dont know how to proceed:
Is two-way replication based on files possible at all?

I read about Snapshots, but to my understanding this replaces the "whole database" without caring about changes made to it and that's why it wont work for two-way exchange.

I would appreciate your hints how to solve this problem in general or whether I should look out for other solutions - MS Access might work with restrictions - but I would prefer SQL Server.

Thanks for reading until here and in advance for your answers.

Regards,

Michael__H

Hi Michael.

I do not think there is an easy solution for your problem. There is no offline file based replication solution that will also do 2-way replication for you.

The closest you can get by is backup restore but that will overwrite your data on the other side.

However if you have even Internet connection, then you will be able to solve your problem by using Web Synchronization which is a new feature in SQL Server Merge replication for SQL Server 2005.

|||

Hello Mahesh,

thank you for your answer.

According to your reply I'm going to solve my problem by using stored procedures writing my own little "replication":

- select records to be altered by our subcontractors
- mark them in separate column as 'currently exported'
- copy to external database/file X
- let our subcontractors complete missing data in database/file X
- compare returned database/file X with records in database marked as 'currently exported'
- import changed records

Of course it won't be easy but as far as no other solution is possible...

Michael

|||

Michael,

Your solution will work but it could be tricky.

Again I encourage you to take a look at Web Synchronization if you remotely think that the subscribers could have atleast internet connection.

|||

Hello Mahesh,

I'll have a closer look at Web-Synchronization , it seems to be a solution. And if not, my "replication" will be used.

Your suggestion has given my a direction for further reading, thank you.

Michael

IS Package doesnt ship with password

Hi,
I tried many times checking "Save password" in connection manager editor. But everytime I open the editor again and I see the password field blank.
I took it as normal, and deployed my IS Package, It couldnt run because of login failed for user 'sa'.

How do I force IS to save password on any ProtectionLevel ?

Thanks,
Fahad

Fahad349 wrote:

Hi,
I tried many times checking "Save password" in connection manager editor. But everytime I open the editor again and I see the password field blank.
I took it as normal, and deployed my IS Package, It couldnt run because of login failed for user 'sa'.

How do I force IS to save password on any ProtectionLevel ?

Thanks,
Fahad

You can't. You'll have to set it through dtexec. SSIS doesn't save passwords. There are plenty of threads in this forum on that topic.|||First, /SET option isnt working
I am trying it this way
U sa /P gama /SET "\Package.Connections[TRIMURTY.TMDB.SA].Properties[ConnectionString]";"Data Source=TRIMURTY;User ID=sa;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False;Password=gama"

Second, I have to run this IS Package from another IS Package as well by using Execute Package Task. How would I supply these things on there ?

Please help me
Thanks
Fahad

Phil Brammer wrote:

Fahad349 wrote:

Hi,
I tried many times checking "Save password" in connection manager editor. But everytime I open the editor again and I see the password field blank.
I took it as normal, and deployed my IS Package, It couldnt run because of login failed for user 'sa'.

How do I force IS to save password on any ProtectionLevel ?

Thanks,
Fahad

You can't. You'll have to set it through dtexec. SSIS doesn't save passwords. There are plenty of threads in this forum on that topic.

|||If you're promoting these packages to the MSDB database in SQL Server, have you looked at using ServerStorage for the ProtectionLevel property?|||I have read about ServerStorage, It has nothing to do with storing connections' passwords but storing the Package.|||

Fahad349 wrote:

I have read about ServerStorage, It has nothing to do with storing connections' passwords but storing the Package.

No, not true. it means it relies on SQL Server to match up the assigned user to the SQL server user account.

ServerStorage: "Protects the whole package using SQL Server database roles."|||Here I am not interested in package protection or package security. I am interested in saving password with package. or to avoid this error "login failed for user 'sa'"

ProtectionLevel ServerStorage doesnt let me save the DTS Package in designer.|||

Fahad349 wrote:

Here I am not interested in package protection or package security. I am interested in saving password with package. or to avoid this error "login failed for user 'sa'"

ProtectionLevel ServerStorage doesnt let me save the DTS Package in designer.

Right, but again, you cannot save the password with the package. Can't do it. When you save to the server, you can choose SQL Server role security. Or, try EncryptSensitiveWithPassword. Using that though, you'll have to issue the password everytime the package executes.|||

Phil Brammer wrote:

Right, but again, you cannot save the password with the package. Can't do it. When you save to the server, you can choose SQL Server role security. Or, try EncryptSensitiveWithPassword. Using that though, you'll have to issue the

Ok I will issue the password, but that password will be to execute dts and its separate from passwords in connection manager.
And my understanding with this error message is; the Executable is unable to open child package for executing, not connection manager inside this child has error.|||

Fahad349 wrote:

Phil Brammer wrote:

Right, but again, you cannot save the password with the package. Can't do it. When you save to the server, you can choose SQL Server role security. Or, try EncryptSensitiveWithPassword. Using that though, you'll have to issue the

Ok I will issue the password, but that password will be to execute dts and its separate from passwords in connection manager.
And my understanding with this error message is; the Executable is unable to open child package for executing, not connection manager inside this child has error.

Tough to say... I would think it's the connection managers that's throwing the error.|||

Search this forum for configuration files then use these to "freeze" the password.

Philippe

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

is my sql server 2005 installed correctly?

I installed sql server 2005 enterprise from my MSDN subscription onto
a Vista business system. problem is I am getting a "no server
connection" message in MS sql server mgmt studio and config manager.
do I have to start the server? How do I do that?
I selected the options to install the northwind database. Where do I
find it?
greatness would be if I could get a TSQL command line prompt. also, I
want to connect to this sql server from my development PC.
thanks,
-SteveHi Steve
"Steve Richter" wrote:
> I installed sql server 2005 enterprise from my MSDN subscription onto
> a Vista business system. problem is I am getting a "no server
> connection" message in MS sql server mgmt studio and config manager.
> do I have to start the server? How do I do that?
> I selected the options to install the northwind database. Where do I
> find it?
> greatness would be if I could get a TSQL command line prompt. also, I
> want to connect to this sql server from my development PC.
> thanks,
> -Steve
>
You require SP2 for SQL Server to work on windows vista. Check the readme
file for additional information required for setting up vista.
You can check the combination of SQL Server and OS at
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
The SQL Server configuration manager tool will show which services are
installed and allow you to stop/start the services.
You may also want to check the setup log files see
http://msdn2.microsoft.com/en-us/library/ms144287.aspx
John|||On Mar 15, 5:28 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Steve
>
>
> "Steve Richter" wrote:
> > I installed sql server 2005 enterprise from my MSDN subscription onto
> > a Vista business system. problem is I am getting a "no server
> > connection" message in MS sql server mgmt studio and config manager.
> > do I have to start the server? How do I do that?
> > I selected the options to install the northwind database. Where do I
> > find it?
> > greatness would be if I could get a TSQL command line prompt. also, I
> > want to connect to this sql server from my development PC.
> > thanks,
> > -Steve
> You require SP2 for SQL Server to work on windows vista. Check the readme
> file for additional information required for setting up vista.
> You can check the combination of SQL Server and OS athttp://msdn2.microsoft.com/en-us/library/ms143506.aspx
> The SQL Server configuration manager tool will show which services are
> installed and allow you to stop/start the services.
> You may also want to check the setup log files seehttp://msdn2.microsoft.com/en-us/library/ms144287.aspx
> John- Hide quoted text -
> - Show quoted text -
thanks. I checked the summary.txt file. It says my PC does not meet
the hardware requirements of sql server. ( it has 512 meg of
memory ).
Is there any way to run sql server w/less than 1 gig of memory?
Microsoft SQL Server 2005 9.00.1399.06
==============================OS Version : Professional (Build 6000)
Time : Sun Mar 11 15:04:51 2007
VISTA2_PC : The current system does not meet the minimum hardware
requirements for this SQL Server release. For system requirements, see
Hardware and Software Requirements, in the readme file or in SQL
Server Books Online.
VISTA2_PC : The current system does not meet minimum hardware
requirements for this SQL Server release. For detailed hardware
requirements, see the readme file or SQL Server Books Online.
VISTA2_PC : Microsoft Internet Information Services (IIS) is either
not installed or is disabled. IIS is required by some SQL Server
features. Without IIS, some SQL Server features will not be available
for installation. To install all SQL Server features, install IIS from
Add or Remove Programs in Control Panel or enable the IIS service
through the Control Panel if it is already installed, and then run SQL
Server Setup again. For a list of features that depend on IIS, see
Features Supported by Editions of SQL Server in Books Online.
Machine : VISTA2_PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_SQLSupport_1.log
----
Machine : VISTA2_PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_SQLNCLI_1.log
----
Machine : VISTA2_PC
Product : Microsoft Visual Studio 2005 Premier Partner Edition
- ENU
Product Version : 8.0.50727.42
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_PPESku_1.log
----
Machine : VISTA2_PC
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_OWC11_1.log
----
Machine : VISTA2_PC
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_BOL_1.log
----
Machine : VISTA2_PC
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_BackwardsCompat_1.log
----
Machine : VISTA2_PC
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_SQLXML4_1.log
----
Machine : VISTA2_PC
Product : Microsoft SQL Server 2005 Tools
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_Tools.log
----
Setup succeeded with the installation, inspect the log file
completely for status on all the components.
Time : Sun Mar 11 23:10:41 2007|||Hi Steve
"Steve Richter" wrote:
> thanks. I checked the summary.txt file. It says my PC does not meet
> the hardware requirements of sql server. ( it has 512 meg of
> memory ).
> Is there any way to run sql server w/less than 1 gig of memory?
>
According to http://msdn2.microsoft.com/en-us/library/ms143506.aspx 512Mb is
the minimum hardware requirement, I assume that not all of it is available
e.g onboard graphics? This requirement will not stop setup, therefore it may
be something else such as processor (which does stop the install) as there
are two failures for the H/W requirements.
John|||On Mar 15, 11:42 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Steve
> "Steve Richter" wrote:
> > thanks. I checked the summary.txt file. It says my PC does not meet
> > the hardware requirements of sql server. ( it has 512 meg of
> > memory ).
> > Is there any way to run sql server w/less than 1 gig of memory?
> According tohttp://msdn2.microsoft.com/en-us/library/ms143506.aspx512Mb is
> the minimum hardware requirement, I assume that not all of it is available
> e.g onboard graphics? This requirement will not stop setup, therefore it may
> be something else such as processor (which does stop the install) as there
> are two failures for the H/W requirements.
> John
my pc reports 511MB of memory. ;)
I called MSFT support and they say sql server 2005 enterprise does not
run on Vista.
just trying to mimic a production envirornment. at this point I am
concluding I have to install more memory and install windows server
2003.
-Steve|||Hi Steve
"Steve Richter" wrote:
> On Mar 15, 11:42 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi Steve
> >
> > "Steve Richter" wrote:
> > > thanks. I checked the summary.txt file. It says my PC does not meet
> > > the hardware requirements of sql server. ( it has 512 meg of
> > > memory ).
> >
> > > Is there any way to run sql server w/less than 1 gig of memory?
> >
> > According tohttp://msdn2.microsoft.com/en-us/library/ms143506.aspx512Mb is
> > the minimum hardware requirement, I assume that not all of it is available
> > e.g onboard graphics? This requirement will not stop setup, therefore it may
> > be something else such as processor (which does stop the install) as there
> > are two failures for the H/W requirements.
> >
> > John
> my pc reports 511MB of memory. ;)
> I called MSFT support and they say sql server 2005 enterprise does not
> run on Vista.
http://msdn2.microsoft.com/en-us/library/ms143506.aspx says 32 bit on 32 bit
for ultimate and above is a valid combination, one must be wrong!
> just trying to mimic a production envirornment. at this point I am
> concluding I have to install more memory and install windows server
> 2003.
If you wish to mimic the environment then having the same OS is important!
Otherwise you could have used developer edition!
> -Steve
John

Is my database connection alive and viable?

Currently, our application is issuing a 'select count(*) from systypes' command to check to see if the database connection is live (has not been reaped by the firewall.) This is somewhat inefficient. Perhaps a less expensive way to implement this functionality is to issue a ping statement to the instance? At least a more simple SQL query is needed.

I'm sure this function is typical in application architecture. What recommendations do you have for confirming that a database connection is alive and viable from the application?

Stephanie

One way is "select 1"...