Relative ConnectionString for SQL Server 2005 Express

I am creating a application in Visual C++ 2005 that has database connections in it. I have gone through the process of setting up the data source and it will work great on my computer. However, the second I move either the project or the created executable to another computer the application keeps crashing. I know that it is crashing due to the database connection string. The string is setup to work only on my computer, I am wondering how do I make, or edit, the string to work on any computer? Thanks for the help.
Have you gone into SQL Server Surface Area Configuration to enable remote connections to the database?

Relationships: Cascade delete

Hi,

I Use SQL Server 2005 Express edition. I have a few tables, which are inter-related. For e.g. I have a project table (ProjectID, Name, ...)

I also have a Project invoice table, in which ProjectID is referred as Foreign key.

Now, I want all the rows in Project invoice (child) table table to be deleted (for a particular ProjetID), if I delete the coresponding ProjectID in Projects (parent) table. If I use the 'on delete set null' or 'on delete cascade' constraint, only the ProjectID (in child table) is nullified whereas rest of the columns have data.

Is there any way out, where the whole ROW (not just that field) is deleted? Or, is it that this can be achieved only by some stored procedure / external program?

Thanks!

Hi !

That is done using "On cascade delete" option. The Null option does the effect you described first, setting the foreign key field to Null. Seems that you have an old vesion of the foreign key in place. Drop the Constraint and recreate it using the "on delete cascade" keywords and you will see that the row will be deleted.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Relationships in Management Studio Express connected to SQL Server Compact Edition

Hello ,
Is possible to specify reationships between tables on SQL Server Compact Edition database in Management Studio Express ?

I can connect to database file , add tables, add data , but I dont't found the right methot to specify reationships as with SQL Server Express.

Any ideas?

Have you found an answer?

Gus

|||

You have to specify the relationships in the query analyzer, like this:

ALTER TABLE MyOrders ADD FK_CustOrder FOREIGN KEY (CustID) REFERENCES MyCustomers(CustID)|||Thanks Erik for the information. I know it can be done in code, I was hoping to find the complete table designer in the ce edition. I understand that it's not there. Apparently 'lightweight' refers not just to the product's functional capabilities, but also its development tools.|||Designing relationships visually will be available in the next version of SQL CE, version 3.5, included in Visual Studio "Orcas".sql

Relationships in Management Studio Express connected to SQL Server Compact Edition

Hello ,
Is possible to specify reationships between tables on SQL Server Compact Edition database in Management Studio Express ?

I can connect to database file , add tables, add data , but I dont't found the right methot to specify reationships as with SQL Server Express.

Any ideas?

Have you found an answer?

Gus

|||

You have to specify the relationships in the query analyzer, like this:

ALTER TABLE MyOrders ADD FK_CustOrder FOREIGN KEY (CustID) REFERENCES MyCustomers(CustID)|||Thanks Erik for the information. I know it can be done in code, I was hoping to find the complete table designer in the ce edition. I understand that it's not there. Apparently 'lightweight' refers not just to the product's functional capabilities, but also its development tools.|||Designing relationships visually will be available in the next version of SQL CE, version 3.5, included in Visual Studio "Orcas".

relationship between xml in xml data type column

How would i express a relation between different kinds of XML segments
in the same table with an XML datatype column.
Further, can i do this using dataset designer? Do you know where I can
get more information on how to use the dataset designer, or how to
write xsd for sql server 2005?
thanks,
Joyce
If the relationship is between elements in the same instance (i.e. same "cell"
in your table) then you can write an XML schema and make use of types xsd:ID
anjd xsd:IDREF. If the relationship is between XML fragments stored in different
rows or columns then this won't work.
Here's a link to the Books On Line page about creating an XML schema collection:
http://msdn2.microsoft.com/en-us/library/ms176009.aspx
If you can post more information on what you're trying to accomplish I'd be glad
to help.
Denis Ruckebusch
http://blogs.msdn.com/denisruc
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"joyce chan" <joyceschan@.fastmail.fm> wrote in message
news:1169140712.945912.315860@.q2g2000cwa.googlegro ups.com...
> How would i express a relation between different kinds of XML segments
> in the same table with an XML datatype column.
> Further, can i do this using dataset designer? Do you know where I can
> get more information on how to use the dataset designer, or how to
> write xsd for sql server 2005?
> thanks,
> Joyce
>
|||hi Denis
This is a helpful start. If I would like to relate between elements in
different row, but in the same column, is there a way to do that?
I'm looking at using Visual Studio dataset designer, and writing out
some queries that can perhaps write the schema out for me.
thanks,
Joyce
Denis Ruckebusch [MSFT] wrote:[vbcol=seagreen]
> If the relationship is between elements in the same instance (i.e. same "cell"
> in your table) then you can write an XML schema and make use of types xsd:ID
> anjd xsd:IDREF. If the relationship is between XML fragments stored in different
> rows or columns then this won't work.
> Here's a link to the Books On Line page about creating an XML schema collection:
> http://msdn2.microsoft.com/en-us/library/ms176009.aspx
> If you can post more information on what you're trying to accomplish I'd be glad
> to help.
>
> Denis Ruckebusch
> http://blogs.msdn.com/denisruc
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "joyce chan" <joyceschan@.fastmail.fm> wrote in message
> news:1169140712.945912.315860@.q2g2000cwa.googlegro ups.com...
|||I'm not familiar with the dataset designer.
I'd look at using relational mechanisms such as id columns to express the
dependency.
Denis Ruckebusch
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"joyce chan" <joyceschan@.fastmail.fm> wrote in message
news:1169218663.655366.182930@.v45g2000cwv.googlegr oups.com...
> hi Denis
> This is a helpful start. If I would like to relate between elements in
> different row, but in the same column, is there a way to do that?
> I'm looking at using Visual Studio dataset designer, and writing out
> some queries that can perhaps write the schema out for me.
> thanks,
> Joyce
> Denis Ruckebusch [MSFT] wrote:
>
|||Hello joyce,
No thats not possible. Schema validation is only on an individual cell.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
[vbcol=seagreen]
> hi Denis
> This is a helpful start. If I would like to relate between elements
> in different row, but in the same column, is there a way to do that?
> I'm looking at using Visual Studio dataset designer, and writing out
> some queries that can perhaps write the schema out for me.
> thanks,
> Joyce
> Denis Ruckebusch [MSFT] wrote:

relationship between xml in xml data type column

How would i express a relation between different kinds of XML segments
in the same table with an XML datatype column.
Further, can i do this using dataset designer? Do you know where I can
get more information on how to use the dataset designer, or how to
write xsd for sql server 2005?
thanks,
JoyceIf the relationship is between elements in the same instance (i.e. same "cel
l"
in your table) then you can write an XML schema and make use of types xsd:I
D
anjd xsd:IDREF. If the relationship is between XML fragments stored in diffe
rent
rows or columns then this won't work.
Here's a link to the Books On Line page about creating an XML schema collect
ion:
http://msdn2.microsoft.com/en-us/library/ms176009.aspx
If you can post more information on what you're trying to accomplish I'd be
glad
to help.
Denis Ruckebusch
http://blogs.msdn.com/denisruc
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"joyce chan" <joyceschan@.fastmail.fm> wrote in message
news:1169140712.945912.315860@.q2g2000cwa.googlegroups.com...
> How would i express a relation between different kinds of XML segments
> in the same table with an XML datatype column.
> Further, can i do this using dataset designer? Do you know where I can
> get more information on how to use the dataset designer, or how to
> write xsd for sql server 2005?
> thanks,
> Joyce
>|||hi Denis
This is a helpful start. If I would like to relate between elements in
different row, but in the same column, is there a way to do that?
I'm looking at using Visual Studio dataset designer, and writing out
some queries that can perhaps write the schema out for me.
thanks,
Joyce
Denis Ruckebusch [MSFT] wrote:
> If the relationship is between elements in the same instance (i.e. same "c
ell"
> in your table) then you can write an XML schema and make use of types xsd
:ID
> anjd xsd:IDREF. If the relationship is between XML fragments stored in dif
ferent
> rows or columns then this won't work.
> Here's a link to the Books On Line page about creating an XML schema colle
ction:
> http://msdn2.microsoft.com/en-us/library/ms176009.aspx
> If you can post more information on what you're trying to accomplish I'd b
e glad
> to help.
>
> Denis Ruckebusch
> http://blogs.msdn.com/denisruc
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "joyce chan" <joyceschan@.fastmail.fm> wrote in message
> news:1169140712.945912.315860@.q2g2000cwa.googlegroups.com...|||I'm not familiar with the dataset designer.
I'd look at using relational mechanisms such as id columns to express the
dependency.
Denis Ruckebusch
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"joyce chan" <joyceschan@.fastmail.fm> wrote in message
news:1169218663.655366.182930@.v45g2000cwv.googlegroups.com...
> hi Denis
> This is a helpful start. If I would like to relate between elements in
> different row, but in the same column, is there a way to do that?
> I'm looking at using Visual Studio dataset designer, and writing out
> some queries that can perhaps write the schema out for me.
> thanks,
> Joyce
> Denis Ruckebusch [MSFT] wrote:
>|||Hello joyce,
No thats not possible. Schema validation is only on an individual cell.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> hi Denis
> This is a helpful start. If I would like to relate between elements
> in different row, but in the same column, is there a way to do that?
> I'm looking at using Visual Studio dataset designer, and writing out
> some queries that can perhaps write the schema out for me.
> thanks,
> Joyce
> Denis Ruckebusch [MSFT] wrote:
>sql

Reinstating Replication on a subscriber automatically

Hi all

I am setting up a system using SQL Server 2005 replicating to both SQL Express and MSDE clients. My question is this - if a client PC has been rebuilt - i.e. new hard disk etc, how can I automatically make that machine realise that it is already a subscriber of a SQL Server database and for it to automatically get a snapshot?

I hope this makes sense, thanks for your help.

D

If the subscriber has the same name as the old one, the SQL Server version of the subscriber is the same as the old one, and the history or distribution retention period has not passed you merely need to restore the subscriber database and the distributor will backfill the missing commands.

If this is not the case you should try to do a no-sync and then a validation to determine what is missing, or how out of sync you are. At that point you might want to evaluate re-initializing.sql

Re-installing SQL Server Express

I recently posted this question in the SQL Server Express forum and it was suggested I also post this issue to this forum. In the hope that someone can shed some light on the problem.

A couple of days ago I installed SQL Server Express and it seemed to be running fine. (I've not really had a lot of time to devote to trying it out).

Today I decided to remove the software as I noticed it placed various components on differnet drives (my fault, I think). Anyway I removed everything using Add/Delete Progams and then deleted any folders left behind.

Now I try a fresh install of SQLEXPR_ADV and I get as far as the "Instance Name" dialog and use the default Named instance of SQLEXPRESS and then click Next.

The next dialog box appears with the heading "Existing components". The three check boxes are grayed out. So I click the Details button and the following is presented on screen:

Name: Microsoft SQL Server 2005 (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Name: Microsoft SQL Server 2005 Reporting Services (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Name: Microsoft SQL Server 2005 Tools
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

It has been pointed out that the following services should have been stopped prior to removal.

SQL Server Active Directory Helper

SQL Server Browser

SQL Server FullTest Search (SQLEXPRESS)

SQL Server Reporting Services (SQLEXPRESS)

Surely this should be managed by the Add/Remove process!

I was able to successfully re-install the program as long as I created a new instance.

What should be the correct process to remove SQL Server Express and if necessary how do I remove services if they do not get deleted?

TIA

Steve

Hmmmm.... for some reason the discovery process is still finding existing components from your original install. When you click on the report button from Add/Remove Programs, do the original install components show up? I'll try to repro it here to see if I hit it. Are both versions SP1? And what is your OS & SP level?

Thanks,
Sam Lester (MSFT)

|||

It could be that the registry entries for the install were not cleaned up correctly, since those services should have been cleaned up by add and remove. There could be multiple reasons, account access could be one of them. Are you sure the same account that installed it was used to uninstall it (or an account with similar privileges)?

Thanks

|||I'm trying to add/remove SQL Server Express via command line. I can successfully install using

sqlexpr.exe /q /qn INSTANCENAME=myinstance DISABLENETWORKPROTOCOLS=0 ADDLOCAL=SQL_DataFiles,Connectivity

My goal is to uninstall just the 'myinstance' instance, and leave other instances alone, so I use

sqlexpr.exe /q /qn INSTANCENAME=myinstance REMOVE=SQL_Data_Files

On the surface, this seems to work. However, when I attempt to re-run the install, the attempt fails, informing me that the instance 'myinstance' already exists. I checked the registry, and discovered a lot of references to 'myinstance' are still there (I stopped counting at a half-dozen). And it seems to make no difference whether I run 'REMOVE=SQL_Data_Files' or 'REMOVE=ALL'.

So I too would like to know of a reliable way to remove a specific instance from a SQL Server Express install so that no traces of that instance remain behind.

|||

Without having the details of the configuration, I do not know what could be the issue related to install/unistall. However, the following link provides full details on how to install and uninstall from a command prompt. Please try and let me know if it helps:

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

Regards,

sql

Re-installing SQL Server Express

I recently posted this question in the SQL Server Express forum and it was suggested I also post this issue to this forum. In the hope that someone can shed some light on the problem.

A couple of days ago I installed SQL Server Express and it seemed to be running fine. (I've not really had a lot of time to devote to trying it out).

Today I decided to remove the software as I noticed it placed various components on differnet drives (my fault, I think). Anyway I removed everything using Add/Delete Progams and then deleted any folders left behind.

Now I try a fresh install of SQLEXPR_ADV and I get as far as the "Instance Name" dialog and use the default Named instance of SQLEXPRESS and then click Next.

The next dialog box appears with the heading "Existing components". The three check boxes are grayed out. So I click the Details button and the following is presented on screen:

Name: Microsoft SQL Server 2005 (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Name: Microsoft SQL Server 2005 Reporting Services (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Name: Microsoft SQL Server 2005 Tools
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

It has been pointed out that the following services should have been stopped prior to removal.

SQL Server Active Directory Helper

SQL Server Browser

SQL Server FullTest Search (SQLEXPRESS)

SQL Server Reporting Services (SQLEXPRESS)

Surely this should be managed by the Add/Remove process!

I was able to successfully re-install the program as long as I created a new instance.

What should be the correct process to remove SQL Server Express and if necessary how do I remove services if they do not get deleted?

TIA

Steve

Hmmmm.... for some reason the discovery process is still finding existing components from your original install. When you click on the report button from Add/Remove Programs, do the original install components show up? I'll try to repro it here to see if I hit it. Are both versions SP1? And what is your OS & SP level?

Thanks,
Sam Lester (MSFT)

|||

It could be that the registry entries for the install were not cleaned up correctly, since those services should have been cleaned up by add and remove. There could be multiple reasons, account access could be one of them. Are you sure the same account that installed it was used to uninstall it (or an account with similar privileges)?

Thanks

|||I'm trying to add/remove SQL Server Express via command line. I can successfully install using

sqlexpr.exe /q /qn INSTANCENAME=myinstance DISABLENETWORKPROTOCOLS=0 ADDLOCAL=SQL_DataFiles,Connectivity

My goal is to uninstall just the 'myinstance' instance, and leave other instances alone, so I use

sqlexpr.exe /q /qn INSTANCENAME=myinstance REMOVE=SQL_Data_Files

On the surface, this seems to work. However, when I attempt to re-run the install, the attempt fails, informing me that the instance 'myinstance' already exists. I checked the registry, and discovered a lot of references to 'myinstance' are still there (I stopped counting at a half-dozen). And it seems to make no difference whether I run 'REMOVE=SQL_Data_Files' or 'REMOVE=ALL'.

So I too would like to know of a reliable way to remove a specific instance from a SQL Server Express install so that no traces of that instance remain behind.

|||

Without having the details of the configuration, I do not know what could be the issue related to install/unistall. However, the following link provides full details on how to install and uninstall from a command prompt. Please try and let me know if it helps:

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

Regards,

Re-installing SQL Server Express

I recently posted this question in the SQL Server Express forum and it was suggested I also post this issue to this forum. In the hope that someone can shed some light on the problem.

A couple of days ago I installed SQL Server Express and it seemed to be running fine. (I've not really had a lot of time to devote to trying it out).

Today I decided to remove the software as I noticed it placed various components on differnet drives (my fault, I think). Anyway I removed everything using Add/Delete Progams and then deleted any folders left behind.

Now I try a fresh install of SQLEXPR_ADV and I get as far as the "Instance Name" dialog and use the default Named instance of SQLEXPRESS and then click Next.

The next dialog box appears with the heading "Existing components". The three check boxes are grayed out. So I click the Details button and the following is presented on screen:

Name: Microsoft SQL Server 2005 (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Name: Microsoft SQL Server 2005 Reporting Services (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Name: Microsoft SQL Server 2005 Tools
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

It has been pointed out that the following services should have been stopped prior to removal.

SQL Server Active Directory Helper

SQL Server Browser

SQL Server FullTest Search (SQLEXPRESS)

SQL Server Reporting Services (SQLEXPRESS)

Surely this should be managed by the Add/Remove process!

I was able to successfully re-install the program as long as I created a new instance.

What should be the correct process to remove SQL Server Express and if necessary how do I remove services if they do not get deleted?

TIA

Steve

Hmmmm.... for some reason the discovery process is still finding existing components from your original install. When you click on the report button from Add/Remove Programs, do the original install components show up? I'll try to repro it here to see if I hit it. Are both versions SP1? And what is your OS & SP level?

Thanks,
Sam Lester (MSFT)

|||

It could be that the registry entries for the install were not cleaned up correctly, since those services should have been cleaned up by add and remove. There could be multiple reasons, account access could be one of them. Are you sure the same account that installed it was used to uninstall it (or an account with similar privileges)?

Thanks

|||I'm trying to add/remove SQL Server Express via command line. I can successfully install using

sqlexpr.exe /q /qn INSTANCENAME=myinstance DISABLENETWORKPROTOCOLS=0 ADDLOCAL=SQL_DataFiles,Connectivity

My goal is to uninstall just the 'myinstance' instance, and leave other instances alone, so I use

sqlexpr.exe /q /qn INSTANCENAME=myinstance REMOVE=SQL_Data_Files

On the surface, this seems to work. However, when I attempt to re-run the install, the attempt fails, informing me that the instance 'myinstance' already exists. I checked the registry, and discovered a lot of references to 'myinstance' are still there (I stopped counting at a half-dozen). And it seems to make no difference whether I run 'REMOVE=SQL_Data_Files' or 'REMOVE=ALL'.

So I too would like to know of a reliable way to remove a specific instance from a SQL Server Express install so that no traces of that instance remain behind.

|||

Without having the details of the configuration, I do not know what could be the issue related to install/unistall. However, the following link provides full details on how to install and uninstall from a command prompt. Please try and let me know if it helps:

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

Regards,

Re-Installation of SQLExpress on XP SP2 Chinese Tra Version

When I installed SQL Express first time a few days ago, it work ok. But, after removing all sql server componets through 'control panel'->'add or remove programs,' something seems wrong in the registry because the re-installation of SQLExpress will never success with an error

-

- Performance Monitor Counter Requirement (Error)
Messages
Performance Monitor Counter Requirement
The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online.

in setup configuration checker. I follow the instructions in help page and try to set the values "Last Counter" and "Last Help" in '[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]' as same as the values "Counter" and "Help" in '[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]'.........but the data type are dword and string resp. So, setup checker will think the values are different and no way to reinstall the SQLExpress.

Can anyone tell me how to fix it or just let me know SQLExpress not for Chinese XP SP2?

Thank you

Hi Andrew,

I've looked over the instructions that you're reading and they are a bit difficult to follow, but they do work once you figure it out. The issue is that you need to find the maximum value for the Counter and Help keys, but because of the data type of the key, the maximum value is not necesarily the last one in the list because they are not sorted numerically. Try to follow the instructions again, but this time when you're looking up the values, be sure to examine all the numbers to get the highest one. Remember they are sorted as strings, so the value list may look like...

1, 10, 11, 12, 13, 14, 2, 3, 4, 5

In this case the highest number if 14, which is in the middle of the list, not the 5 at the end. The first time I went though this myself I automactically picked the last number in the value list assuming it was numerically sorted; I was wrong. Hopefully this will solve the issue for you.

Mike

|||Thanks for your explanation and the problem is solved. sql

Re-Index SQL Server Express User Instance?

Is there a way to re-index a SQL Server Express User Instance? If I try to open the .mdf while the website is still running, I get a message stating that the file is in use. If I shut down the web service and open the .mdf, then restart the website, then the website cannot access the .mdf while I have it open in VStudio (reminds me a lot of Access).

In the past I tried to open a user instance with SQL Server Management Studio, but then it goofed up my user-instance...so I am hesitant to try that again. Is there any way to re-index?

Thanks!

Backup and restore and adjust Web.Config, then ALTER Table drop INDEX and REINDEX, the reason is currently your User Instance is behaving like a separate instance of SQL Server and that is not valid. Hope this helps.

http://forums.asp.net/thread/1454694.aspx

Registry for SQL Server Express Instance

I notice that the following registries:
HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.2\MSSQLServer\SuperSocketNeLib
HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\SQLEXPRESS\MSSQLServer\SuperSocke
tNeLib
They seem to be for the same instance. But the first one has very detail
information which match what you will see the SQL Server Configuration
Manager. What is the purpose for having 2 registry for the same instance?Did you make sure that this is for the same instance ? I think this is from
another instance running on your computer. Do you only have SQL Server
Express installed or any other instances running ? Did you try to change a
value in the supersocket area, like the listened port to see if it will be
also reflected in the other area ? Also make sure if the TCP settings do not
differ, because a port can only be aquired by ONE service at a time.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:02B46A81-22E7-4DAA-9FC1-7FA978C027FE@.microsoft.com...
>I notice that the following registries:
> HKLM\SOFTWARE\Microsoft\Microsoft SQL
> Server\MSSQL.2\MSSQLServer\SuperSocketNeLib
> HKLM\SOFTWARE\Microsoft\Microsoft SQL
> Server\SQLEXPRESS\MSSQLServer\SuperSocke
tNeLib
> They seem to be for the same instance. But the first one has very detail
> information which match what you will see the SQL Server Configuration
> Manager. What is the purpose for having 2 registry for the same
> instance?
>

Registration Problem

I tried to Register the SQL Express. I received the Email to comfirmation and verification but I don't received Any Key!

Can some one help me?

Thanks

Actually you don′t need to register within SQL Server Express, this will bring you only additional benefits like information about updates and other news about SQL Server (and as far as I can remeber some benefits), but since SQL Server Express is free you don′t even need to register nor need a license code.

HTH, Jens K. Suessmeyer.

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

Jens is correct, no key is needed. We do like people to register though; the registration process offers some benefits as well as the option to get updates about patches, etc. Registration also allows us to better understand how people are using SQL Express (there are a few questions), which helps me do a better job designing the next version of SQL Express.

Mike

|||

Is there a evaluation copy for SQL2005/ Reporting Server 2005? How Can we verify if we have installed a trial version? And how can this be permanetly activated?

Prasanna

vvprasanna@.yahoo.com

|||

Yes there is a trial version: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=6931fa7f-c094-49a2-a050-2d07993566ec

Refer to the following snippet from the MS site:

Upgrading and Uninstalling the Trial Software

The 180-day trial version of SQL Server 2005 Enterprise Edition can be upgraded to the fully licensed version of SQL Server 2005 Enterprise Edition without uninstalling the trial software prior to the end of the 180-day period. If upgrading to the fully licensed version of SQL Server 2005 Standard Edition, Workgroup Edition, or Developer Edition, it is recommended that you uninstall the 180-day trial version of SQL Server 2005 Enterprise Edition before installing the fully licensed version of the other editions. Please refer to the product documentation for information about upgrading to the fully licensed software.

http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx

If you want to upgrade the product you should do that before the trial period has ended to avoid problems like this:
http://support.microsoft.com/kb/914158/en-us

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

It's also worth noting that SQL Express with Advanced Services includes Reporting Services free of charge. There are some limitation as is common with free products, but it might meet you needs. Check out the feature comparison by Edition.

Mike

Registered Servers are unavailable

So I've had some issues upgrading to SQL Server Mgmt Studio Dev from Express. I finally got everything upgraded / installed and I see the instances that I was using with Express in my Registered Servers window but I can't connect to any of them. After looking in my Microsoft SQL Server directory I noticed that there are no MSSQL.# folders. How can I recreate these or create a new instance on my local machine?

Hi,

Do you mean that you want to import the SQLExpress database intoSQL Server management Stuido Expresswhich provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express).? If so, you can use "aspnet_regsql" tool and try again, the tool exists in DiskRoot:\WINDOWS\Microsoft.NET\Framework\versionEdtion\.

Thanks.