How to get the Windows login name?

How to get the Windows login name inside SQL Server 2005 when the SQL Server
2005 is accessed thru terminal service? Cannot use .Net.Additional Information:
SQL Server 2005 is connected using SQL Authentication.
"Peter" wrote:

> How to get the Windows login name inside SQL Server 2005 when the SQL Serv
er
> 2005 is accessed thru terminal service? Cannot use .Net.|||You can't. SQL Server only knows the user as the SQL login.
-Sue
On Thu, 8 Mar 2007 16:52:03 -0800, Peter
<Peter@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Additional Information:
>SQL Server 2005 is connected using SQL Authentication.
>
>
>"Peter" wrote:
>|||Peter,
What client protocol are you using?
Chris
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:6442C4B1-5DC4-41F9-BCA6-410A3D95F50B@.microsoft.com...[vbcol=seagreen]
> Additional Information:
> SQL Server 2005 is connected using SQL Authentication.
>
>
> "Peter" wrote:
>

How to get the URL to access a report?

hi, all

I am just starting to use the SQL Server 2005 report service. And I also made some reports, and I am thinking how to get the URL to access the report, especially when I have some parameters need to be passed into the report.

Basically it's something like this:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&Year=2002

where Year is a parameter. Check the SQl Server Books Online for URL access.|||

Thanks.

More detail is at http://msdn2.microsoft.com/en-us/library/ms153586.aspx

|||Hi,
How if i want to pass my reporting server login credential in the url?

How to get the URL to access a report?

hi, all

I am just starting to use the SQL Server 2005 report service. And I also made some reports, and I am thinking how to get the URL to access the report, especially when I have some parameters need to be passed into the report.

Basically it's something like this:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&Year=2002

where Year is a parameter. Check the SQl Server Books Online for URL access.|||

Thanks.

More detail is at http://msdn2.microsoft.com/en-us/library/ms153586.aspx

|||Hi,
How if i want to pass my reporting server login credential in the url?

How to get the URL to access a report?

hi, all
I am just starting to use the SQL Server 2005 report service. And I
also made some reports, and I am thinking how to get the URL to access
the report, especially when I have some parameters need to be passed
into the report.THe easiest way to get the URL is simply to run the report from Report
Manager, then copy the URL from IE..
ALso read about URL access and parameters for RS in the Books on Line... It
will tell you how you can change the URL to add parameters, do rendering
options..etc
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Nick" wrote:
> hi, all
> I am just starting to use the SQL Server 2005 report service. And I
> also made some reports, and I am thinking how to get the URL to access
> the report, especially when I have some parameters need to be passed
> into the report.
>sql

How to get the exact installed Version

OK, this is a simple question for you, but i am a newbie to SQL2000, and i need to find out which Service Pack we are currently running. Could anybody please give me a short reply :)
Thanks
Chrisselect @.@.version|||Originally posted by blindman
select @.@.version

great thank you. This helped a lot.

Chris

How to get the database location of a installed reporting service?

I have reporting service installed, but I didn't install it. I
cannot figure out where the reporting service database located. We
have two SQL servers and the databases reside on BOTH servers. Also
the resportserver.mdb and reportservertempdb.mdb files reside on both
servers (obviously) and both have fairly recent dates. It's quite
possible that someone else on my network has a Report Server running.
How can I figure out *which* database is mine'
Thank you.If you are running RS 2005 then on your report server you will have an app
called Reporting Services Configuration. When you run it, it shows a variety
of configuration options including the database.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<doug.masters@.gmail.com> wrote in message
news:1176912515.518742.324170@.o5g2000hsb.googlegroups.com...
>I have reporting service installed, but I didn't install it. I
> cannot figure out where the reporting service database located. We
> have two SQL servers and the databases reside on BOTH servers. Also
> the resportserver.mdb and reportservertempdb.mdb files reside on both
> servers (obviously) and both have fairly recent dates. It's quite
> possible that someone else on my network has a Report Server running.
> How can I figure out *which* database is mine'
> Thank you.|||On Apr 18, 11:52 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> If you are running RS 2005 then on your report server you will have an app
> called Reporting Services Configuration. When you run it, it shows a variety
> of configuration options including the database.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
Sorry, I forgot that little tidbit of info... Reporting Services
2000|||On Apr 18, 11:08 am, doug.mast...@.gmail.com wrote:
> I have reporting service installed, but I didn't install it. I
> cannot figure out where the reporting service database located. We
> have two SQL servers and the databases reside on BOTH servers. Also
> the resportserver.mdb and reportservertempdb.mdb files reside on both
> servers (obviously) and both have fairly recent dates. It's quite
> possible that someone else on my network has a Report Server running.
> How can I figure out *which* database is mine'
> Thank you.
OK, I've poked thru files & the registry to see if I can find ou the
path to the databses and no luck. Anyone know how to find this in
RS 2000?

How to get SQL Server Service Pack information

Hi,
The below result i get from running xp_msver, but is this information
showing any SQL service pack information?
How can i get it?
1,ProductName,NULL,Microsoft SQL Server
2,ProductVersion,524288,8.00.760
3,Language,1033,English (United States)
4,Platform,NULL,NT INTEL X86
5,Comments,NULL,NT INTEL X86
6,CompanyName,NULL,Microsoft Corporation
7,FileDescription,NULL,SQL Server Windows NT
8,FileVersion,NULL,2000.080.0760.00
9,InternalName,NULL,SQLSERVR
10,LegalCopyright,NULL,© 1988-2003 Microsoft Corp. All rights reserved.
11,LegalTrademarks,NULL,Microsoft® is a registered trademark of Microsoft
Corporation. Windows(TM) is a trademark of Microsoft Corporation
12,OriginalFilename,NULL,SQLSERVR.EXE
13,PrivateBuild,NULL,NULL
14,SpecialBuild,49807360,NULL
15,WindowsVersion,143851525,5.0 (2195)
16,ProcessorCount,1,1
17,ProcessorActiveMask,1,00000001
18,ProcessorType,586,PROCESSOR_INTEL_PENTIUM
19,PhysicalMemory,511,511 (536264704)
20,Product ID,NULL,NULL
--
Kzeto NgHi,
From the output the service pack level for your SQL Server is SP3 (
2,ProductVersion,524288,8.00.760 )
Thanks
Hari
MCDBA
"Kzeto ng" <kzetong@.yahoo.com> wrote in message
news:ev9prZIuDHA.3220@.tk2msftngp13.phx.gbl...
> Hi,
> The below result i get from running xp_msver, but is this information
> showing any SQL service pack information?
> How can i get it?
>
> 1,ProductName,NULL,Microsoft SQL Server
> 2,ProductVersion,524288,8.00.760
> 3,Language,1033,English (United States)
> 4,Platform,NULL,NT INTEL X86
> 5,Comments,NULL,NT INTEL X86
> 6,CompanyName,NULL,Microsoft Corporation
> 7,FileDescription,NULL,SQL Server Windows NT
> 8,FileVersion,NULL,2000.080.0760.00
> 9,InternalName,NULL,SQLSERVR
> 10,LegalCopyright,NULL,© 1988-2003 Microsoft Corp. All rights reserved.
> 11,LegalTrademarks,NULL,Microsoft® is a registered trademark of Microsoft
> Corporation. Windows(TM) is a trademark of Microsoft Corporation
> 12,OriginalFilename,NULL,SQLSERVR.EXE
> 13,PrivateBuild,NULL,NULL
> 14,SpecialBuild,49807360,NULL
> 15,WindowsVersion,143851525,5.0 (2195)
> 16,ProcessorCount,1,1
> 17,ProcessorActiveMask,1,00000001
> 18,ProcessorType,586,PROCESSOR_INTEL_PENTIUM
> 19,PhysicalMemory,511,511 (536264704)
> 20,Product ID,NULL,NULL
>
>
> --
> Kzeto Ng
>|||http://www.aspfaq.com/2160
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kzeto ng" <kzetong@.yahoo.com> wrote in message
news:ev9prZIuDHA.3220@.tk2msftngp13.phx.gbl...
> Hi,
> The below result i get from running xp_msver, but is this information
> showing any SQL service pack information?
> How can i get it?
>
> 1,ProductName,NULL,Microsoft SQL Server
> 2,ProductVersion,524288,8.00.760
> 3,Language,1033,English (United States)
> 4,Platform,NULL,NT INTEL X86
> 5,Comments,NULL,NT INTEL X86
> 6,CompanyName,NULL,Microsoft Corporation
> 7,FileDescription,NULL,SQL Server Windows NT
> 8,FileVersion,NULL,2000.080.0760.00
> 9,InternalName,NULL,SQLSERVR
> 10,LegalCopyright,NULL,© 1988-2003 Microsoft Corp. All rights reserved.
> 11,LegalTrademarks,NULL,Microsoft® is a registered trademark of Microsoft
> Corporation. Windows(TM) is a trademark of Microsoft Corporation
> 12,OriginalFilename,NULL,SQLSERVR.EXE
> 13,PrivateBuild,NULL,NULL
> 14,SpecialBuild,49807360,NULL
> 15,WindowsVersion,143851525,5.0 (2195)
> 16,ProcessorCount,1,1
> 17,ProcessorActiveMask,1,00000001
> 18,ProcessorType,586,PROCESSOR_INTEL_PENTIUM
> 19,PhysicalMemory,511,511 (536264704)
> 20,Product ID,NULL,NULL
>
>
> --
> Kzeto Ng
>

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 SQL Server + Service Pack Information

Hi,
I wondering that, does SQL have any sys_proc that able to tell what SQL
version that i am using and service pack.
Thank you
--
Regard,
Kzeto Ngselect @.@.version
"Kzeto ng" <kzetong@.yahoo.com> wrote in message
news:uEmag1TxDHA.1196@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I wondering that, does SQL have any sys_proc that able to tell what SQL
> version that i am using and service pack.
> Thank you
> --
> Regard,
> Kzeto Ng
>|||select @.@.version
Mark Baekdal
www.dbghost.com
>--Original Message--
>Hi,
> I wondering that, does SQL have any sys_proc that able
to tell what SQL
>version that i am using and service pack.
> Thank you
>--
>Regard,
>Kzeto Ng
>
>.
>

How to get service accounts for 150 servers

Hi Everyone.

I have 150 SQL servers (2000 MSDE). They all run using various domain accounts as their service logins. Is there an automated way to find out those service logins? Maybe a query I could run on each server?

I really do not want to go to each of those 150 servers and look at their properties manualy! :S

Any help would be greatly appreciated! Thank you.Something around the master.dbo.sysusers and/or master.dbo.syslogins
table(s) ?|||I think that you want the startname value from this (http://www.microsoft.com/technet/scriptcenter/scripts/os/services/ossvvb08.mspx) script.

-PatP|||I think that you want the startname value from this (http://www.microsoft.com/technet/scriptcenter/scripts/os/services/ossvvb08.mspx) script.

-PatP

Yeah, I would think that WMI would be your best bet. Dump the list of servers into a text file (or XML). Open that file using the File system object and spin through (using oFile.ReadLine). Then feed the string value (the computer name) into a function that returns the name of of the service account you are looking for. Dump that into a separate text file (or a database).

Regards,

hmscott|||Thank you everyone for responding. I got an answer at experts-exchange. The following query will return the service account:

declare @.rc int,
@.dir nvarchar(4000)
exec @.rc = master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'System\CurrentControlSet\S ervices\MSSQLServer\',N'ObjectName', @.dir output, 'no_output'
select @.dir

I've modified it put the result in the central table and then ran it through a SQL loop. Worked perfectly! :D

WMI would have worked as well, but this solution took just 10 min to implement.

P.S. Had no idea that something like xp_instance_regread existed. Is too much to hope that sql server 2005 will have better documentation? :-)|||That Transact-SQL code will work nicely as long as you only need the default instance of SQL 2000.

-PatP|||That Transact-SQL code will work nicely as long as you only need the default instance of SQL 2000.

-PatP

Good point, Pat. For named instances the command will need to be modified:

declare @.rc int,
@.dir nvarchar(4000)
exec @.rc = master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'System\CurrentControlSet\S ervices\MSSQL$Your_Instance_Name\',N'ObjectName', @.dir output, 'no_output'
select @.dir