How to get the SQLEXPRESS GUID ?

Hi, please can someone be so kind and tell me the fastet way to get the GUID of the running SQLExpress instance ?

Sincerely,gonzo883.

hi,

what do you mean by "the GUID of the running SQLExpress instance"?

regards

|||

I mean the GUID of my SQLExpress server, I need the GUID because I want to use SSL encryption and to register SSL via httpcfg so I need the GUID.

Sincerely,gonzo883.

|||

hi,

GUID string identifying the entity registering the certificate. As a best practice, create one GUID for each instance of SQL Server 2005 and use that same GUID for all certificate registrations made by that instance.

so just "create" your own guid (as no one is directly present nor available from the instance) and save that value for your references..

regards

|||

Thank you for your reply, but I don't know how to create a own guid for my instance od SQLExpress. Can you please explain this.

Sincerely,gonzo883.

|||

OK, I've registert the certificate, but I have some more problems to get the whole think working :

I've created a certificate with selfssl for my server (cn=www.example.de) and have registered it via '/T' for the default web site.

After that I've controled via httpcfg query ssl if the certificate is really registered to the server.

Now I try to set the SQLExpress server to use the encryption in the configuration manager, but the certificate was not shown in the dialogue field. I check 'force encryption' and try to reach the server from a client.

With the web browser if can connect via https after accepting the certificate, I also add the certificate to the 'trusted' ones on the client.

When I try to connect to the server using the SQL management studio with the option 'encrypt' I get an error message that server could be reached but the certificate was a trusted one.

What I have to do on the client that the certificate would be seen as a trusted one.

I also have exported the certificate from the server as a *.pfx file and have imported it to the client, but I still get the error message .

Sorry for my bad english,gonzo883.

How to get the SQLEXPRESS GUID ?

Hi, please can someone be so kind and tell me the fastet way to get the GUID of the running SQLExpress instance ?

Sincerely,gonzo883.

hi,

what do you mean by "the GUID of the running SQLExpress instance"?

regards

|||

I mean the GUID of my SQLExpress server, I need the GUID because I want to use SSL encryption and to register SSL via httpcfg so I need the GUID.

Sincerely,gonzo883.

|||

hi,

GUID string identifying the entity registering the certificate. As a best practice, create one GUID for each instance of SQL Server 2005 and use that same GUID for all certificate registrations made by that instance.

so just "create" your own guid (as no one is directly present nor available from the instance) and save that value for your references..

regards

|||

Thank you for your reply, but I don't know how to create a own guid for my instance od SQLExpress. Can you please explain this.

Sincerely,gonzo883.

|||

OK, I've registert the certificate, but I have some more problems to get the whole think working :

I've created a certificate with selfssl for my server (cn=www.example.de) and have registered it via '/T' for the default web site.

After that I've controled via httpcfg query ssl if the certificate is really registered to the server.

Now I try to set the SQLExpress server to use the encryption in the configuration manager, but the certificate was not shown in the dialogue field. I check 'force encryption' and try to reach the server from a client.

With the web browser if can connect via https after accepting the certificate, I also add the certificate to the 'trusted' ones on the client.

When I try to connect to the server using the SQL management studio with the option 'encrypt' I get an error message that server could be reached but the certificate was a trusted one.

What I have to do on the client that the certificate would be seen as a trusted one.

I also have exported the certificate from the server as a *.pfx file and have imported it to the client, but I still get the error message .

Sorry for my bad english,gonzo883.

sql

How to get rid of the GUID?

If I decide I don't want to use Queued Updating Subscribers, how do I get the replication guid's added off the tables in my database? A restore?
I am testing all my options, and have completed testing the use of queued updating, and want to move on to another option, but the guid's are causing me some problems, and I want to know if there is a sp to get rid of them or do I just need to restore my database?
Thanx!
JLS,
there is no sp to remove these columns. Usually there is no issue as TSQL is
writte using column names rather than columns by position. However, if you
have this sort of statement:
insert into tableX
select * from tableY
Then admittedly there will be issues.
You ask about restoring the database but I'm not too sure which one you are
referring to. If it is the production database and you are using replication
for failover, it would seem to be redundant?
Regards,
Paul Ibison