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 SQL Server Info(Version/SP Version/Server Statistics) from a network.

Does anyone know how to get SQL Server versions, Service pack versions
and the Server that instance of SQL is running on a network. I have
seen some threads on how to list SQL servers in a network but I need to
find more info about these SQL servers.

Any help appreciated..!
Thx...SELECT @.@.VERSION

--
Regards Bagieta
~~~~~~~~~~~~~~~~~~~~~~~~~~~
dbDeveloper - Multiple databases editor
http://www.prominentus.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~

How to get Physical Drives associated with SQL Instance

I need to get a list of physical drives (ie: drive
letters) of all the drives associated with an instance of
SQL 2000 running on a cluster.
The ideal solution would be a stored procedure that given
the instance name you would get back the drives.
Can anyone make a useful suggestion? Is this possible with
a stored procedure?
Thanks,
kenKen,
You can use master..xp_fixeddrives to get the fixed drives name as well as
free space in MB.Since its a undocumented call, please refrain from using it
in production code.An alternative would be to use master..xp_cmdshell
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Ken McClain" <ken@.softbreeze.net> wrote in message
news:0b8e01c35062$4e3466e0$a501280a@.phx.gbl...
> I need to get a list of physical drives (ie: drive
> letters) of all the drives associated with an instance of
> SQL 2000 running on a cluster.
> The ideal solution would be a stored procedure that given
> the instance name you would get back the drives.
> Can anyone make a useful suggestion? Is this possible with
> a stored procedure?
> Thanks,
> ken|||In addition to Dinesh's suggestion which I can't recall if it works on a
cluster there is also the system function fn_servershareddrives() that will
give you the shared cluster drives, possibly combining them will give you
the answer, I haven't got a cluster to test on at the moment. See BOL for
details of this function
SELECT *
FROM ::fn_servershareddrives()
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ken McClain" <ken@.softbreeze.net> wrote in message
news:0b8e01c35062$4e3466e0$a501280a@.phx.gbl...
I need to get a list of physical drives (ie: drive
letters) of all the drives associated with an instance of
SQL 2000 running on a cluster.
The ideal solution would be a stored procedure that given
the instance name you would get back the drives.
Can anyone make a useful suggestion? Is this possible with
a stored procedure?
Thanks,
ken

How to get overall total and total of specific instance?

I'm pretty new to SSAS, so I looked through the forum to see if this had been answered. I couldn't find it, but if its here please let me know.

I have a simple fact table of vendors and products purchased: Vendor, Part, Qty

Multiple Vendors can carry the same Part. I want to display the total Qty over all Vendors and the total Qty by a specific vendor for a specific Part purchased.

Example:

Vendor Part Qty TotalQTY

001 5x 3 10

002 4c 1 8

003 4c 7 8

004 6q 9 15

001 6q 6 15

What would be the best way to go about this?

Thanks in advance!

This 1st row of sample data is confusing, because it seems to be the only row for Part 5x; but maybe a row is missing:

Vendor Part Qty TotalQTY

001 5x 3 10

Anyway, assuming that there are Vendor and Part dimensions and a [Qty] "sum" measure, [TotalQty] could simply be like:

([Measures].[Qty], [Vendor].[Vendor].[All Vendors])

|||Thank you very much! I can see why you are an MVP.