Can not get sqlcmd and unable to create peer-to-peer replication.

Hi, Pros,

I am new to SQL server 2005. We have installed SQL server 2005 cluster. I tried to setup peer-to-peer replication with another standard server. Unfortunately, when I creating publication, I got error message : SQL server cound not configure "MyServer" as a Distributor [New publication Wizard] Additional information: An exception occurred whild executing a Transact_SQL statement or batch.

The Server "Myserveris already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisitingDistributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard. Changed database context to 'master'. [Microsoft SQL Server, Error: 14099]

I tried to use sqlcmd and I got another error message:

C:\>sqlcmd

HResult 0x2, Level 16, State 1

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi

shing a connection to the server. When connecting to SQL Server 2005, this failu

re may be caused by the fact that under the default settings SQL Server does not

allow remote connections..

Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

Does anyone have any idea how to get the sqlcmd work?

Thank you in advance.

Hi Vicent,

You should use "sqlcmd -S %VirtualInstanceName%" (replace %VirtualInstanceName% with the virtual server name of your cluster.

For the issue of setting up distributor, have you follow the instruction in your error message?

Peng

|||

Hi, Peng,

Thanks for your kind reply. I am so glad your command works. I got another error when I tried to drop distributor from my cluster because when I setup replication the message shows the cluster has been setup as distributor.

I use sqlcmd to drop distributor and get the error message below. Do you have any idea?

C:\>sqlcmd -S myvirtualname
1> sp_dropdistributor 'myvirtualname'
2> GO
HResult 0x1FB2, Level 16, State 5
Error converting data type varchar to bit.
1>

Thanks for your help.

|||

Hi Vincent,

The first parameter of sp_dropdistributor is not server name. Please see this page (http://msdn2.microsoft.com/en-us/library/ms173516.aspx) for the document. For example, you should say "EXEC sp_dropdistributor" or "EXEC sp_dropdistributor 1".

Peng

|||

Hi, Peng,

I tried the command EXEC, it does not work either.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\HCLLCLUS>sqlcmd -S myvirtualname
1> EXEC sp_dropdistributor 'myvirtualname'
2> GO
HResult 0x1FB2, Level 16, State 5
Error converting data type varchar to bit.
1>

Do you know how to fix? Do I need to log on machine instead of virtual name? I wonder how did this distributor setup. Is there any way I can check this?

Thanks,

|||

I need to mention one more thing. I did follow the error message and tried to find Disable Publication and Distributor Wizard. It was not there. It seems the only way left for me is the command line.

Thanks.

|||

It is really my bad. I use the command to drop off distributor.

1> EXEC sp_dropdistributor
2> GO
Msg 21043, Level 16, State 1, Server virtualserver, Procedure sp_dropdistributor,
Line 50
The Distributor is not installed.
1>

It is looks like the ditributor did not installed on the server. However if I tried to configure replication via wizard, the error message shows the distributor was installed.

SQL Server could not configure ‘virtualname’ as a Distributor.

Additional information.

An exception occurred while executing a Transact-SQL statement or batch.

[Microsoft.SqlServer.ConnectionInfo]

The server ‘Virtualname’ is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the existing Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard. Changed database context to ‘master’. [Microsoft SQL Server Error: 14099]

|||

Could you run the following command against your cluster instance and report the result back?

SELECT srvname FROM master.dbo.sysservers WHERE srvstatus & 8 <> 0

If you get any row back, it means that your server is already defined as distributor.

Peng

|||

Hi, Peng,

I am glad to tell you. I have resolved this problem. Actually, there was a security problem when I set up replication. I went to Local Security Settings >User Rights Assignment >Lock pages in memory, I put adminstrator user in it and I was able to setup replication. Thanks for your instruction.

I have an another problem. I did not realize that it need SQL Server 2005 Enterprise edition to setup P2P replication. I had bought upraged license. However, I do not know how to upgrade SQL server 2005 standard to Enterprise edition. Does anyone know how? Thank you.

|||Run setup from the command prompt. Here are instructions on how to do this.

http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade

Can not get sqlcmd and unable to create peer-to-peer replication.

Hi, Pros,

I am new to SQL server 2005. We have installed SQL server 2005 cluster. I tried to setup peer-to-peer replication with another standard server. Unfortunately, when I creating publication, I got error message : SQL server cound not configure "MyServer" as a Distributor [New publication Wizard] Additional information: An exception occurred whild executing a Transact_SQL statement or batch.

The Server "Myserveris already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisitingDistributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard. Changed database context to 'master'. [Microsoft SQL Server, Error: 14099]

I tried to use sqlcmd and I got another error message:

C:\>sqlcmd

HResult 0x2, Level 16, State 1

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi

shing a connection to the server. When connecting to SQL Server 2005, this failu

re may be caused by the fact that under the default settings SQL Server does not

allow remote connections..

Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

Does anyone have any idea how to get the sqlcmd work?

Thank you in advance.

Hi Vicent,

You should use "sqlcmd -S %VirtualInstanceName%" (replace %VirtualInstanceName% with the virtual server name of your cluster.

For the issue of setting up distributor, have you follow the instruction in your error message?

Peng

|||

Hi, Peng,

Thanks for your kind reply. I am so glad your command works. I got another error when I tried to drop distributor from my cluster because when I setup replication the message shows the cluster has been setup as distributor.

I use sqlcmd to drop distributor and get the error message below. Do you have any idea?

C:\>sqlcmd -S myvirtualname
1> sp_dropdistributor 'myvirtualname'
2> GO
HResult 0x1FB2, Level 16, State 5
Error converting data type varchar to bit.
1>

Thanks for your help.

|||

Hi Vincent,

The first parameter of sp_dropdistributor is not server name. Please see this page (http://msdn2.microsoft.com/en-us/library/ms173516.aspx) for the document. For example, you should say "EXEC sp_dropdistributor" or "EXEC sp_dropdistributor 1".

Peng

|||

Hi, Peng,

I tried the command EXEC, it does not work either.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\HCLLCLUS>sqlcmd -S myvirtualname
1> EXEC sp_dropdistributor 'myvirtualname'
2> GO
HResult 0x1FB2, Level 16, State 5
Error converting data type varchar to bit.
1>

Do you know how to fix? Do I need to log on machine instead of virtual name? I wonder how did this distributor setup. Is there any way I can check this?

Thanks,

|||

I need to mention one more thing. I did follow the error message and tried to find Disable Publication and Distributor Wizard. It was not there. It seems the only way left for me is the command line.

Thanks.

|||

It is really my bad. I use the command to drop off distributor.

1> EXEC sp_dropdistributor
2> GO
Msg 21043, Level 16, State 1, Server virtualserver, Procedure sp_dropdistributor,
Line 50
The Distributor is not installed.
1>

It is looks like the ditributor did not installed on the server. However if I tried to configure replication via wizard, the error message shows the distributor was installed.

SQL Server could not configure ‘virtualname’ as a Distributor.

Additional information.

An exception occurred while executing a Transact-SQL statement or batch.

[Microsoft.SqlServer.ConnectionInfo]

The server ‘Virtualname’ is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the existing Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard. Changed database context to ‘master’. [Microsoft SQL Server Error: 14099]

|||

Could you run the following command against your cluster instance and report the result back?

SELECT srvname FROM master.dbo.sysservers WHERE srvstatus & 8 <> 0

If you get any row back, it means that your server is already defined as distributor.

Peng

|||

Hi, Peng,

I am glad to tell you. I have resolved this problem. Actually, there was a security problem when I set up replication. I went to Local Security Settings >User Rights Assignment >Lock pages in memory, I put adminstrator user in it and I was able to setup replication. Thanks for your instruction.

I have an another problem. I did not realize that it need SQL Server 2005 Enterprise edition to setup P2P replication. I had bought upraged license. However, I do not know how to upgrade SQL server 2005 standard to Enterprise edition. Does anyone know how? Thank you.

|||Run setup from the command prompt. Here are instructions on how to do this.

http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade

Can not get sqlcmd and unable to create peer-to-peer replication.

Hi, Pros,

I am new to SQL server 2005. We have installed SQL server 2005 cluster. I tried to setup peer-to-peer replication with another standard server. Unfortunately, when I creating publication, I got error message : SQL server cound not configure "MyServer" as a Distributor [New publication Wizard] Additional information: An exception occurred whild executing a Transact_SQL statement or batch.

The Server "Myserveris already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisitingDistributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard. Changed database context to 'master'. [Microsoft SQL Server, Error: 14099]

I tried to use sqlcmd and I got another error message:

C:\>sqlcmd

HResult 0x2, Level 16, State 1

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi

shing a connection to the server. When connecting to SQL Server 2005, this failu

re may be caused by the fact that under the default settings SQL Server does not

allow remote connections..

Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

Does anyone have any idea how to get the sqlcmd work?

Thank you in advance.

Hi Vicent,

You should use "sqlcmd -S %VirtualInstanceName%" (replace %VirtualInstanceName% with the virtual server name of your cluster.

For the issue of setting up distributor, have you follow the instruction in your error message?

Peng

|||

Hi, Peng,

Thanks for your kind reply. I am so glad your command works. I got another error when I tried to drop distributor from my cluster because when I setup replication the message shows the cluster has been setup as distributor.

I use sqlcmd to drop distributor and get the error message below. Do you have any idea?

C:\>sqlcmd -S myvirtualname
1> sp_dropdistributor 'myvirtualname'
2> GO
HResult 0x1FB2, Level 16, State 5
Error converting data type varchar to bit.
1>

Thanks for your help.

|||

Hi Vincent,

The first parameter of sp_dropdistributor is not server name. Please see this page (http://msdn2.microsoft.com/en-us/library/ms173516.aspx) for the document. For example, you should say "EXEC sp_dropdistributor" or "EXEC sp_dropdistributor 1".

Peng

|||

Hi, Peng,

I tried the command EXEC, it does not work either.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\HCLLCLUS>sqlcmd -S myvirtualname
1> EXEC sp_dropdistributor 'myvirtualname'
2> GO
HResult 0x1FB2, Level 16, State 5
Error converting data type varchar to bit.
1>

Do you know how to fix? Do I need to log on machine instead of virtual name? I wonder how did this distributor setup. Is there any way I can check this?

Thanks,

|||

I need to mention one more thing. I did follow the error message and tried to find Disable Publication and Distributor Wizard. It was not there. It seems the only way left for me is the command line.

Thanks.

|||

It is really my bad. I use the command to drop off distributor.

1> EXEC sp_dropdistributor
2> GO
Msg 21043, Level 16, State 1, Server virtualserver, Procedure sp_dropdistributor,
Line 50
The Distributor is not installed.
1>

It is looks like the ditributor did not installed on the server. However if I tried to configure replication via wizard, the error message shows the distributor was installed.

SQL Server could not configure ‘virtualname’ as a Distributor.

Additional information.

An exception occurred while executing a Transact-SQL statement or batch.

[Microsoft.SqlServer.ConnectionInfo]

The server ‘Virtualname’ is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the existing Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard. Changed database context to ‘master’. [Microsoft SQL Server Error: 14099]

|||

Could you run the following command against your cluster instance and report the result back?

SELECT srvname FROM master.dbo.sysservers WHERE srvstatus & 8 <> 0

If you get any row back, it means that your server is already defined as distributor.

Peng

|||

Hi, Peng,

I am glad to tell you. I have resolved this problem. Actually, there was a security problem when I set up replication. I went to Local Security Settings >User Rights Assignment >Lock pages in memory, I put adminstrator user in it and I was able to setup replication. Thanks for your instruction.

I have an another problem. I did not realize that it need SQL Server 2005 Enterprise edition to setup P2P replication. I had bought upraged license. However, I do not know how to upgrade SQL server 2005 standard to Enterprise edition. Does anyone know how? Thank you.

|||Run setup from the command prompt. Here are instructions on how to do this.

http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgradesql

Can not get sqlcmd and unable to create peer-to-peer replication.

Hi, Pros,

I am new to SQL server 2005. We have installed SQL server 2005 cluster. I tried to setup peer-to-peer replication with another standard server. Unfortunately, when I creating publication, I got error message : SQL server cound not configure "MyServer" as a Distributor [New publication Wizard] Additional information: An exception occurred whild executing a Transact_SQL statement or batch.

The Server "Myserveris already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisitingDistributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard. Changed database context to 'master'. [Microsoft SQL Server, Error: 14099]

I tried to use sqlcmd and I got another error message:

C:\>sqlcmd

HResult 0x2, Level 16, State 1

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi

shing a connection to the server. When connecting to SQL Server 2005, this failu

re may be caused by the fact that under the default settings SQL Server does not

allow remote connections..

Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

Does anyone have any idea how to get the sqlcmd work?

Thank you in advance.

Hi Vicent,

You should use "sqlcmd -S %VirtualInstanceName%" (replace %VirtualInstanceName% with the virtual server name of your cluster.

For the issue of setting up distributor, have you follow the instruction in your error message?

Peng

|||

Hi, Peng,

Thanks for your kind reply. I am so glad your command works. I got another error when I tried to drop distributor from my cluster because when I setup replication the message shows the cluster has been setup as distributor.

I use sqlcmd to drop distributor and get the error message below. Do you have any idea?

C:\>sqlcmd -S myvirtualname
1> sp_dropdistributor 'myvirtualname'
2> GO
HResult 0x1FB2, Level 16, State 5
Error converting data type varchar to bit.
1>

Thanks for your help.

|||

Hi Vincent,

The first parameter of sp_dropdistributor is not server name. Please see this page (http://msdn2.microsoft.com/en-us/library/ms173516.aspx) for the document. For example, you should say "EXEC sp_dropdistributor" or "EXEC sp_dropdistributor 1".

Peng

|||

Hi, Peng,

I tried the command EXEC, it does not work either.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\HCLLCLUS>sqlcmd -S myvirtualname
1> EXEC sp_dropdistributor 'myvirtualname'
2> GO
HResult 0x1FB2, Level 16, State 5
Error converting data type varchar to bit.
1>

Do you know how to fix? Do I need to log on machine instead of virtual name? I wonder how did this distributor setup. Is there any way I can check this?

Thanks,

|||

I need to mention one more thing. I did follow the error message and tried to find Disable Publication and Distributor Wizard. It was not there. It seems the only way left for me is the command line.

Thanks.

|||

It is really my bad. I use the command to drop off distributor.

1> EXEC sp_dropdistributor
2> GO
Msg 21043, Level 16, State 1, Server virtualserver, Procedure sp_dropdistributor,
Line 50
The Distributor is not installed.
1>

It is looks like the ditributor did not installed on the server. However if I tried to configure replication via wizard, the error message shows the distributor was installed.

SQL Server could not configure ‘virtualname’ as a Distributor.

Additional information.

An exception occurred while executing a Transact-SQL statement or batch.

[Microsoft.SqlServer.ConnectionInfo]

The server ‘Virtualname’ is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the existing Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard. Changed database context to ‘master’. [Microsoft SQL Server Error: 14099]

|||

Could you run the following command against your cluster instance and report the result back?

SELECT srvname FROM master.dbo.sysservers WHERE srvstatus & 8 <> 0

If you get any row back, it means that your server is already defined as distributor.

Peng

|||

Hi, Peng,

I am glad to tell you. I have resolved this problem. Actually, there was a security problem when I set up replication. I went to Local Security Settings >User Rights Assignment >Lock pages in memory, I put adminstrator user in it and I was able to setup replication. Thanks for your instruction.

I have an another problem. I did not realize that it need SQL Server 2005 Enterprise edition to setup P2P replication. I had bought upraged license. However, I do not know how to upgrade SQL server 2005 standard to Enterprise edition. Does anyone know how? Thank you.

|||Run setup from the command prompt. Here are instructions on how to do this.

http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade

Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

can i use SQL server 2005 standard to create and host db for website?

Hi guys,

I am just wondering what's the difference of sql server 2005 standard and enterprise editions. can I use SQL server 2005 to host a database for a website?

Thanks!

Daren

You can find an overview of the features on the Microsoft website (here).
Hosting a database for a website on a Standard Edition is perfectly possible. Enterprise Edition is for really large environments, so if you are expecting millions of hits per day it might be better to use EE because of it's extra features for high level/load databases. But a lot of databases will run just fine on Standard Edition.
|||thanks for the feedback!

Can I use MSDE in a Microsoft's Corporate Client

I Work in a Corporation where SQL is not an standard to deploy but office 2000 are desktop utilities by default. They use access, word, excell, etc to work. Can I use MSDE with Vb 6 and how can I administer the MSDE database ? I have seen Access frontend
to make changes and permisions and its very poor. Can I use Sql Server Console or Third parts ?
Thanks
hi,
"Designer improving costs" <janou_dank@.yahoo.com.ar> ha scritto nel
messaggio news:F799D60E-DC43-480E-BE57-6EC9E7C02B47@.microsoft.com...
> I Work in a Corporation where SQL is not an standard to deploy but office
2000 are desktop utilities
>by default. They use access, word, excell, etc to work. Can I use MSDE with
Vb 6 and how can I
>administer the MSDE database ? I have seen Access frontend to make changes
and permisions and
>its very poor. Can I use Sql Server Console or Third parts ?
> Thanks
you can download and install MSDE for sure in corporate environments, as
MSDE release A (http://www.microsoft.com/sql/msde/do...s/download.asp) is
free..
as regard management, you can use SQL Server management tools like
Enterprise Manager and Query Analyzer only if you a licensed owner of a full
SQL Server edition, but you can write your own tool, use Acces and/or resort
to third parties tools like those provided at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||If you have licensed SQL Server ownership with which the tools are
available, you can use the tools to manage the MSDE installations.

Can I use data drive subscription on a remote sql standard version

I would like to upgrade our report server to sql 2000 enterprise
edition to be able to use the DD subscriptions.. if I do do upgrade the
server, will I be able to connect to a sql server on another box with
the standard version and continue to use DD subscriptions on that
remote server.
or is there another way to get around this issue by way of stored
procedures.. thanks.What specifically do you mean by "continue to use DD susbscriptions no that
remote server"? Do you mean the remote server is the source of data that
drives the DD subscription? In that case, yes.
-Tim
"Joaquin" <joaquin.pineda@.gmail.com> wrote in message
news:1147897141.934976.263120@.38g2000cwa.googlegroups.com...
>I would like to upgrade our report server to sql 2000 enterprise
> edition to be able to use the DD subscriptions.. if I do do upgrade the
> server, will I be able to connect to a sql server on another box with
> the standard version and continue to use DD subscriptions on that
> remote server.
> or is there another way to get around this issue by way of stored
> procedures.. thanks.
>|||Tim Dot NoSpam wrote:
> What specifically do you mean by "continue to use DD susbscriptions no that
> remote server"? Do you mean the remote server is the source of data that
> drives the DD subscription? In that case, yes.
>
Tim, you got it, that's what I wanted to know. also, do you know if its
possible to simulate dd subscriptions, let say by way of stored proc?
on standard version of sql. thanks.

Can I use 4 Gb memory for each instance of Standard Edition?

Hello!

I have installed SQL Server 2005 Standard Edition on 64 bit Windows 2003.

My question is if I can use more than 4 Gb Physical Memory?

Can I install another instance of SQL Server 2005 Standard Edition and use another 4 Gb Physical Memory for that instance?

Is the limitation of 4 Gb memory usage for the whole SQL Server or for each instance?

Hi Fari,

I am just curious as to why you would want multiple instances on one machine. Why dont you just have another database?|||

Hi!

It's "cheaper" to install another instance of sql server then buying another hardware and installing W2003! We are discussing differnt senarios. If buying another server is the only option, then thats the alternativ vi have to take.

|||

What is the physical memory available/installed on this server?

One of the article refers:

For 32-bit installations, the use of address windowing extensions (AWE) memory has been improved so that SQL Server 2005 Standard Edition can use more than 3GB of RAM. Also, with 64-bit processors increasingly more prolific and affordable, the benefits of 64-bit server installations are becoming much more accessible. A 64-bit architecture provides significantly larger directly addressable memory space (compared to 32-bit) for all database operations, and eliminates the need for the AWE mechanism.

|||

Hi!

We have 6 GB physical memory availabe on our 64- bit server.

I found in other places in books online that I can use as much memory as installed on the server and that I do not need to use AWE on the 64 bit server.

Is that true?

|||

Yes if its a 64 bit then need not use AWE settings.

Check on SQL Server properties about the memory settings to see how much is allocated, also run SYSMON to capture the resource usage.

|||Thanks for your help!

can i script subscriptions?

I have about 150 subscriptions to create on our Standard Edition of RS. Is
there a way for me to script these or create them programmatically? Your
help is greatly appreciated.Yes, use the rs.exe utility to call the SOAP API.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:9143BBF8-0632-41CA-838F-905854FC39B6@.microsoft.com...
>I have about 150 subscriptions to create on our Standard Edition of RS. Is
> there a way for me to script these or create them programmatically? Your
> help is greatly appreciated.

Can i save SQL Server 2005 Db as SS 2000?

Hi,

on my dev-machine i am running SQL Server 2005 Standard Edition.
Now i have to do a project for a client who is on a server with ASP.NET 1.1 and SQL Server 2000.

Is there a way i can build his database in 2005 and export or whatever it as SQL Server 2000?

I don't really like the idea of installing 2000 and 2005 side by side on the same machine.

Thank you very much in advance.

Tjerk HeringaIt depends on what features you use. If you stick to 2000 style, you'd prbly be able to develop on 2005 and move it to 2000.

Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

I think you're asking if there's some way to temporarily turn off features in the Dev Edition that aren't available in the Standard Edition. That's an interesting idea but it's not something we support directly in SQL Server 2005. To absolutely insure that you didn't include any non-STD features in your app or to get precise STD performance/footprint characteristics, I guess you need a copy of STD.

Paul

|||

>> I guess you need a copy of STD.

Which Sexually Transmitted Disease does he need? (That's the common meaning of the acronym STD).

It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands.

Josh

Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

I think you're asking if there's some way to temporarily turn off features in the Dev Edition that aren't available in the Standard Edition. That's an interesting idea but it's not something we support directly in SQL Server 2005. To absolutely insure that you didn't include any non-STD features in your app or to get precise STD performance/footprint characteristics, I guess you need a copy of STD.

Paul

|||

>> I guess you need a copy of STD.

Which Sexually Transmitted Disease does he need? (That's the common meaning of the acronym STD).

It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands.

Josh

Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

I think you're asking if there's some way to temporarily turn off features in the Dev Edition that aren't available in the Standard Edition. That's an interesting idea but it's not something we support directly in SQL Server 2005. To absolutely insure that you didn't include any non-STD features in your app or to get precise STD performance/footprint characteristics, I guess you need a copy of STD.

Paul

|||

>> I guess you need a copy of STD.

Which Sexually Transmitted Disease does he need? (That's the common meaning of the acronym STD).

It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands.

Josh

Can I replace SQL Server Standard Edition with MSDE?

Hi,
We have a software that is developed by using MS SQL Server Standard
Edition. The vendor claims that the software cannot be used with MSDE.
The question is:
Are MSDE and SQL Server Standard Edition exactly the same from a software
point of view? Can I replace the standard edition with MSDE? Are there points
that should be considered in doing this replacement?
Thanks,
GG
I don't know the pure "from a software point of view", however, if the
software requires so many connections that exceeds MSDE can do, then you are
doomed. So it's not only the pure software.
"GG" <GG@.discussions.microsoft.com> wrote in message
news:3B2A4FC7-B056-4B88-9781-7777473DD7AA@.microsoft.com...
> Hi,
> We have a software that is developed by using MS SQL Server Standard
> Edition. The vendor claims that the software cannot be used with MSDE.
> The question is:
> Are MSDE and SQL Server Standard Edition exactly the same from a software
> point of view? Can I replace the standard edition with MSDE? Are there
> points
> that should be considered in doing this replacement?
> Thanks,
> GG

Can I replace SQL Server Standard Edition with MSDE?

Hi,
We have a software that is developed by using MS SQL Server Standard
Edition. The vendor claims that the software cannot be used with MSDE.
The question is:
Are MSDE and SQL Server Standard Edition exactly the same from a software
point of view? Can I replace the standard edition with MSDE? Are there point
s
that should be considered in doing this replacement?
Thanks,
GGI don't know the pure "from a software point of view", however, if the
software requires so many connections that exceeds MSDE can do, then you are
doomed. So it's not only the pure software.
"GG" <GG@.discussions.microsoft.com> wrote in message
news:3B2A4FC7-B056-4B88-9781-7777473DD7AA@.microsoft.com...
> Hi,
> We have a software that is developed by using MS SQL Server Standard
> Edition. The vendor claims that the software cannot be used with MSDE.
> The question is:
> Are MSDE and SQL Server Standard Edition exactly the same from a software
> point of view? Can I replace the standard edition with MSDE? Are there
> points
> that should be considered in doing this replacement?
> Thanks,
> GG

Can I replace SQL Server Standard Edition with MSDE?

Hi,
We have a software that is developed by using MS SQL Server Standard
Edition. The vendor claims that the software cannot be used with MSDE.
The question is:
Are MSDE and SQL Server Standard Edition exactly the same from a software
point of view? Can I replace the standard edition with MSDE? Are there points
that should be considered in doing this replacement?
Thanks,
GGI don't know the pure "from a software point of view", however, if the
software requires so many connections that exceeds MSDE can do, then you are
doomed. So it's not only the pure software.
"GG" <GG@.discussions.microsoft.com> wrote in message
news:3B2A4FC7-B056-4B88-9781-7777473DD7AA@.microsoft.com...
> Hi,
> We have a software that is developed by using MS SQL Server Standard
> Edition. The vendor claims that the software cannot be used with MSDE.
> The question is:
> Are MSDE and SQL Server Standard Edition exactly the same from a software
> point of view? Can I replace the standard edition with MSDE? Are there
> points
> that should be considered in doing this replacement?
> Thanks,
> GG

Can I replace SQL Server Standard Edition with MSDE?

Hi,
We have a software that is developed by using MS SQL Server Standard
Edition. The vendor claims that the software cannot be used with MSDE.
The question is:
Are MSDE and SQL Server Standard Edition exactly the same from a software
point of view? Can I replace the standard edition with MSDE? Are there points
that should be considered in doing this replacement?
Thanks,
GG
hi,
GG wrote:
> Hi,
> We have a software that is developed by using MS SQL Server Standard
> Edition. The vendor claims that the software cannot be used with MSDE.
> The question is:
> Are MSDE and SQL Server Standard Edition exactly the same from a
> software point of view? Can I replace the standard edition with MSDE?
> Are there points that should be considered in doing this replacement?
> Thanks,
> GG
they both share the same code base, and actually are the same, but they do
have different in-built limitations..
MSDE includes a Query Governor that kicks in when 8 (5user+3system)
concurrent workloads are executed slowing down the whole system, it limits
CPU (2) and memory use (2gb) , it limits database size (2gb), it does not
provide FullText and Analysis Services, nor does it support Reporting
Services..
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
it depends on your ISV requirements...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply