Showing posts with label service. Show all posts

Monday, March 26, 2012

Help with setting up Reporting Services

I am trying to set up Reporting Services. I am using SQL Server 2005.

I installed service pack 2 for SQL Server 2005. The database looks to be set up in the configuration manager. When I try to deploy the report I get the following message:

A connection could not be made to the report serverhttp://localhost/ReportServer

When trying to open the ReportServer folder in IIS I get another message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Exception has been thrown by the target of an invocation.
Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

I am not sure what SharePoint is and why I need it. I am just trying to set up simple reports on a local host SQL database and IIS on a standalone PC.

Any help appreciated.

Thanks

This is just a guess. In the IIS admin tool in Control Panel/Administrative Tools, check the Properties on the Reports (and ReportServer) virtual directories under Default Web Site and make sure they are set to the Application pool "ReportServer" (or "DefaultAppPool" if there is no ReportServer pool) and not "MSSharepointAppPool".|||This probably has something to do with the Sharepoint integration that is a part of sp2. You can run Reporting Services in Integrated Mode (instead of Native Mode), and it will synchronize your report directory in Reporting Services with a site in MOSS or WSS. If you don't want to use this, ensure you are in Native Mode. Go to Microsoft SQL Server 2005 --> Configuration Tools --> Reporting Services Configuration. Then click on the tab "Database Setup". If you've installed sp2, you will see a line called "Server Mode:".|||

I recently installed SQL Server 2005 SP2 and I'm receiving this same error.

When I bring up the Reporting Services Configuration tool, and go to "Database Setup" as you say, I do in fact see a "Server Mode" line and it's set to "SharePoint Integrated".

How do I turn this off / fix the problem?

Thanx for any help in advance.

|||

I found my answer here:http://msdn2.microsoft.com/en-us/library/bb326407.aspx

help with service account permissions

i decided to see if i could better secure one of my test servers so
here's what i did.
created two local nt accounts (one for the sqlserver service and one for
agent) that are not local admins.
through enterprise manager i changed the agent and server to run using
the appropriate account.
both the server and agent start, but aren't working properly.
i get the following errors in the sqlagent error log
[LOG] The data portion of event 17052 from MSSQLSERVER is invalid
i get the following error every time i try to start a job
error 22022 :sqlserveragent is not currently running so it cannot be
notified of this action.
the agent is running (i even see the account that runs the agent is
connected to msdb).
i see no errors in the sqlserver log, but i do see the following errors
in the nt application log.
You do not have sufficient operating system permission to open the
sqlserveragent status event.
i checked the user rights for both local nt accounts and they have the
following granted to them
act as part of o/s
bypass traverse checking
lock pages in memory
log on as a batch job
log on as a service
replace a process level token
kb 283811 says they also need the "increase quotas" permission, but that
doesn't sound like the cause of the errors.
i haven't checked all the registry permissions those two accounts need,
but that doesn't sound like the cause of the error either.
any ideas?i forgot to mention this is sql2000 sp3, win2k latest updates.
also, i went back and added both nt accounts to local admin group and
everything is working properly again.
chxxx wrote:
> i decided to see if i could better secure one of my test servers so
> here's what i did.
> created two local nt accounts (one for the sqlserver service and one for
> agent) that are not local admins.
> through enterprise manager i changed the agent and server to run using
> the appropriate account.
> both the server and agent start, but aren't working properly.
> i get the following errors in the sqlagent error log
> [LOG] The data portion of event 17052 from MSSQLSERVER is invalid
> i get the following error every time i try to start a job
> error 22022 :sqlserveragent is not currently running so it cannot be
> notified of this action.
> the agent is running (i even see the account that runs the agent is
> connected to msdb).
> i see no errors in the sqlserver log, but i do see the following errors
> in the nt application log.
> You do not have sufficient operating system permission to open the
> sqlserveragent status event.
> i checked the user rights for both local nt accounts and they have the
> following granted to them
> act as part of o/s
> bypass traverse checking
> lock pages in memory
> log on as a batch job
> log on as a service
> replace a process level token
> kb 283811 says they also need the "increase quotas" permission, but that
> doesn't sound like the cause of the errors.
> i haven't checked all the registry permissions those two accounts need,
> but that doesn't sound like the cause of the error either.
> any ideas?

Wednesday, March 21, 2012

help with reporting services

I installed sql express with advanced services on a local network computer named 'Tester'. For service accounts I used 'network service' and 'mixed mode' for authentication. I would like to publish database reports using reporting services. when i open a web browser on the machine with sql express and type in the url: http://localhost/reports or http://localhost/reportserver the web pages work fine. but when i go to a different machine thats on the same network and use the url: http://Tester/reports or http://Tester/reportserver the web page is not found. how do i get users on the network to be able to view the virtual report server directories on the Tester computer? Help would be greatly appreciated.

Hi,

did you check your IIS configuration of your localhost (Tester)?

Is there an alias for your network computer - "Tester", DNS?

Have you put in a Hostheadername by IP?

What about a ping`?

Have you test http://172.../reports ?

tosc

|||i can ping 'Tester' fine, i've tried http://<ip of host>/reports. IIS is configured for integrated windows autentication. I tried setting authentication to allow anonymous access but that didnt work either.|||

Hi John,

by installation, have you check "Use SSL..." checkbox in the installation wizard?

tosc

|||

are you referring to the install of IIS? I dont recall, should I try to reinstall IIS?

Thanks,

John

|||

Hi John,

NO, i'm referring to Installing and Configuring SQL Server Reporting Services!

Have yopu check "Use SSL..." checkbox in the installation wizard?

tosc

|||

Hi John,

Unless you changed it manually, Reporting Services is given an instance name just like the database service. Try adding "$SQLEXPRESS" (without quotes) to the end of your URL. Needless to say, if you installed to a different instance name, use that inplace of SQLEXPRESS.

Mike

|||I've tried all the url's and none of them work. Does IIS have to be configured in a particular way? also do I need to add permissions to my report server database? I would think that anyone on the intranet who knows the host computer name can put in the url and view the reportserver web page. Im not getting prompted for a login, my web browser just says the page cannot be displayed, that makes me think that it is network problem and not a configuration problem on the local machine.|||

I have had similar troubles. I have a report server configured on a computer on the network. I've installed SQL Express 2005 and the toolkits to get hold of RS. The computer is running IIS 5 and is connected using MMC. Reports can be generated, deployed, and viewed using a browser and URL from this machine quite happily.

However, when I try to access the report server from a different computer on the network I also get a

Internet Explorer cannot display the webpage

message.

I have tried:

http://rs_name/reports

http://rs_name.network.local/reports

http://rs_name/reports$sqlexpress

I can ping the machines from eachother successfully and I have made profiles from within Report Manager for each user on these machines. Is this a Express thing? SURELY, you must be able to access these reports across a Windows network.

Many thanks.

Leslie

|||

You sould ask this question in the Report Services forum to get a better answer. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)

Mike

|||

OK. I'll ask them over there. Thank you very much, and apoligies for being in the wrong place.

help with reporting services

Hi,

did you check your IIS configuration of your localhost (Tester)?

Is there an alias for your network computer - "Tester", DNS?

Have you put in a Hostheadername by IP?

What about a ping`?

Have you test http://172.../reports ?

tosc

Hi John,

by installation, have you check "Use SSL..." checkbox in the installation wizard?

tosc

|||

are you referring to the install of IIS? I dont recall, should I try to reinstall IIS?

Thanks,

John

|||

Hi John,

NO, i'm referring to Installing and Configuring SQL Server Reporting Services!

Have yopu check "Use SSL..." checkbox in the installation wizard?

tosc

|||

Hi John,

Mike

However, when I try to access the report server from a different computer on the network I also get a

Internet Explorer cannot display the webpage

message.

I have tried:

http://rs_name/reports

http://rs_name.network.local/reports

http://rs_name/reports$sqlexpress

Many thanks.

Leslie

|||

You sould ask this question in the Report Services forum to get a better answer. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)

Mike

|||

OK. I'll ask them over there. Thank you very much, and apoligies for being in the wrong place.

Monday, March 19, 2012

Help with query formatting

Hi all,
I have one table that contains, among other fields, a NAME and 14 SERVICE
fields. The ID number is obvious and the SERVICE fields contain a "Y" if
that particular person (NAME) carries out the service. A person can carry
out 1 or more services or the person can carry no service.
I am trying to write a search screen where the user will enter a partial
name and select 1 or more services to be included. The query will then
return and person who's name is LIKE the entry AND who has at least 1 of the
entered services.
I have the following: "SELECT * FROM PROVIDERS WHERE [first name] LIKE
'%TOM%' AND srv1 = 'Y' OR srv2 = 'Y' OR srv3='Y'.
What I am getting from the above is all people with TOM in their name AND
service 1. I am also getting people - no matter what their name is - with
either service 2 or service 3.
I need all people with TOM in their name and EITHER service 1, service 2 or
service 3.
Any help is appreciated.
George
George,
You need to add parentheses around the (this OR that OR other...).
The priority of boolean operators is that AND is evaluated before OR.
SELECT *
FROM PROVIDERS
WHERE [first name] LIKE '%TOM%'
AND (
srv1 = 'Y' OR srv2 = 'Y' OR srv3='Y'
)
(Ultimately, you will probably have more luck with any sizeable
application if you do not use 14 different Y/N columns. Almost
always, it is a better design to maintain a separate table to record
that information. My suggestion should get you moving forward,
but there is always the risk that it moves you forward closer to the
quicksand.)
Steve Kass
Drew University
George wrote:

>Hi all,
>I have one table that contains, among other fields, a NAME and 14 SERVICE
>fields. The ID number is obvious and the SERVICE fields contain a "Y" if
>that particular person (NAME) carries out the service. A person can carry
>out 1 or more services or the person can carry no service.
>I am trying to write a search screen where the user will enter a partial
>name and select 1 or more services to be included. The query will then
>return and person who's name is LIKE the entry AND who has at least 1 of the
>entered services.
>I have the following: "SELECT * FROM PROVIDERS WHERE [first name] LIKE
>'%TOM%' AND srv1 = 'Y' OR srv2 = 'Y' OR srv3='Y'.
>What I am getting from the above is all people with TOM in their name AND
>service 1. I am also getting people - no matter what their name is - with
>either service 2 or service 3.
>I need all people with TOM in their name and EITHER service 1, service 2 or
>service 3.
>Any help is appreciated.
>George
>

Monday, February 27, 2012

help with my select

I hope this is the right place.

I have a proc here, it selects the data needed, but when i put in a sum aggrate the service if sumed up, but it sums all of the records. what i am trying to do is sum up the first service fees that appear.

would you folks be kind and point me in the right direction as how i can acomplish this?

here is my proc code.

DECLARE @.EOBFileName NVARCHAR(50)
SET @.EOBFileName = 'B835255227__CHSEP__2107032414052256619'
SELECT DISTINCT ISNULL(slp.pkServiceLinePayment, 0) AS PaymentKey
, ISNULL(slp.fkClaim, 0) AS ClaimKey
, ISNULL(slp.fkServiceLine, 0) AS ServiceLineKey
, ISNULL(slp.fkInsurance, 0) AS InsuranceKEy
, ISNULL(slp.ServiceDate, 0) AS ServiceDate
, ISNULL(slp.ServiceCode, 0) AS ServiceCode
, ISNULL(slp.ServiceFee, '') AS ServiceFee
, ISNULL(slp.InsurancePayment, '') AS InsurancePayment
, ISNULL(c.fkRenderingServiceProvider, '') AS ProviderKey
, ISNULL(ent.NM103, '') AS ProviderName
, ISNULL(slp.CurrentStatus, '') AS Status
, ISNULL(pat.NM103, '') + ', ' + ISNULL(pat.NM104, '') AS PatientName
, ISNULL(ins.PlanID, '') AS Policy
, ISNULL(ins.GroupPlanID, '') AS GroupID
, ISNULL(slp.PayerClaimTrace, '') AS ClaimTrace
, ISNULL(slpa.GroupCode, '') AS GroupCode
, ISNULL(grp.CodeDescription, '') AS GroupDescription
, ISNULL(slpa.ReasonCode1, '') AS ReasonCode1
, ISNULL(rcode1.CodeDescription, '') AS ReasonDesc1
, ISNULL(slpa.MonetaryAmount1, '') AS Amount1
, ISNULL(slpa.Quantity1, 1) AS Qt1
, ISNULL(slpa.ReasonCode2, '') AS ReasonCode2
, ISNULL(rcode2.CodeDescription, '') AS ReasonDesc2
, ISNULL(slpa.MonetaryAmount2, '') AS Amount2
, ISNULL(slpa.Quantity2, '') AS Qt2
, ISNULL(slpa.ReasonCode3, '') AS ReasonCode3
, ISNULL(rcode3.CodeDescription, '') AS ReasonDesc3
, ISNULL(slpa.MonetaryAmount3, '') AS Amount3
, ISNULL(slpa.Quantity3, '') AS Qt3
, ISNULL(slpa.ReasonCode4, '') AS ReasonCode4
, ISNULL(rcode4.CodeDescription, '') AS ReasonDesc4
, ISNULL(slpa.MonetaryAmount4, '') AS Amount4
, ISNULL(slpa.Quantity4, '') AS Qt4
, ISNULL(slpa.ReasonCode5, '') AS ReasonCode5
, ISNULL(rcode5.CodeDescription, '') AS ReasonDesc5
, ISNULL(slpa.MonetaryAmount5, '') AS Amount5
, ISNULL(slpa.Quantity5, '') AS Qt5
, ISNULL(slpa.ReasonCode6, '') AS ReasonCode6
, ISNULL(rcode6.CodeDescription, '') AS ReasonDesc6
, ISNULL(slpa.MonetaryAmount6, '') AS Amount6
, ISNULL(slpa.Quantity6, '') AS Qt6
, ISNULL(slpr.Qualifier + ' ' + slpr.RemarkCode + ' - ' + rkcode.CodeDescription, '') AS Remark
FROM tbl_ServiceLine_Payments slp
INNER JOIN tbl_Claim_Info c
ON slp.fkClaim = c.pkClaim
INNER JOIN tbl_Entities ent
ON c.fkRenderingServiceProvider = ent.pkEntity
INNER JOIN tbl_Entities pat
ON c.fkPatient = pat.pkEntity
INNER JOIN tbl_Patient_Insurance_Plans ins
ON slp.fkInsurance = ins.pkInsurance
LEFT OUTER JOIN tbl_ServiceLine_Payments_AdjustmentCodes slpa
ON slp.pkServiceLinePayment = slpa.fkServiceLinePayment
LEFT OUTER JOIN tbl_Claim_Adjustment_Group_Codes grp
ON slpa.GroupCode = grp.ClaimAdjustmentGroupCode
LEFT OUTER JOIN tbl_Claim_Adjustment_Reason_Codes rcode1
ON slpa.ReasonCode1 = rcode1.ClaimAdjustmentReasonCode
LEFT OUTER JOIN tbl_Claim_Adjustment_Reason_Codes rcode2
ON slpa.ReasonCode2 = rcode2.ClaimAdjustmentReasonCode
LEFT OUTER JOIN tbl_Claim_Adjustment_Reason_Codes rcode3
ON slpa.ReasonCode3 = rcode3.ClaimAdjustmentReasonCode
LEFT OUTER JOIN tbl_Claim_Adjustment_Reason_Codes rcode4
ON slpa.ReasonCode4 = rcode4.ClaimAdjustmentReasonCode
LEFT OUTER JOIN tbl_Claim_Adjustment_Reason_Codes rcode5
ON slpa.ReasonCode5 = rcode5.ClaimAdjustmentReasonCode
LEFT OUTER JOIN tbl_Claim_Adjustment_Reason_Codes rcode6
ON slpa.ReasonCode6 = rcode6.ClaimAdjustmentReasonCode
LEFT OUTER JOIN dbo.tbl_ServiceLine_Payments_RemarkCodes slpr
ON slp.pkServiceLinePayment = slpr.fkServiceLinePayment
LEFT OUTER JOIN dbo.tbl_Claim_Advice_Remark_Codes rkcode
ON slpr.RemarkCode = rkcode.ClaimAdviceRemarkCode
WHERE (slp.EOBFileName LIKE @.EOBFileName)
ORDER BY ClaimKey, PaymentKey

here is the table that is created.

PaymentKey ClaimKey ServiceLineKey InsuranceKEy ServiceDate ServiceCode ServiceFee InsurancePayment ProviderKey ProviderName Status PatientName Policy GroupID ClaimTrace GroupCode GroupDescription ReasonCode1 ReasonDesc1 Amount1 Qt1 ReasonCode2 ReasonDesc2 Amount2 Qt2 ReasonCode3 ReasonDesc3 Amount3 Qt3 ReasonCode4 ReasonDesc4 Amount4 Qt4 ReasonCode5 ReasonDesc5 Amount5 Qt5 ReasonCode6 ReasonDesc6 Amount6 Qt6 Remark
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
1107 52 5589 416 02/12/2007 97124 22.00 17.6 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 CO Contractual Obligations A2 Contractual adjustment. 4.40 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0
1108 52 5588 416 02/12/2007 97014 15.00 11.84 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 CO Contractual Obligations A2 Contractual adjustment. 2.96 0 42 Charges exceed our fee schedule or maximum allowable amount. 0.20 0 0.00 0 0.00 0 0.00 0 0.00 0 HE N14 - Payment based on a contractual amount or agreement, fee schedule, or maximum allowable amount.
1109 52 5587 416 02/12/2007 98941 36.00 13.8 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 CO Contractual Obligations A2 Contractual adjustment. 7.20 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0
1109 52 5587 416 02/12/2007 98941 36.00 13.8 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 PR Patient Responsibility 2 Coinsurance Amount. 15.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0
1110 52 5586 416 02/10/2007 72100 38.00 30.4 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 CO Contractual Obligations A2 Contractual adjustment. 7.60 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0
1111 52 5585 416 02/10/2007 72040 35.00 28 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 CO Contractual Obligations A2 Contractual adjustment. 7.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0
1112 52 5584 416 02/10/2007 97014 15.00 11.84 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 CO Contractual Obligations A2 Contractual adjustment. 2.96 0 42 Charges exceed our fee schedule or maximum allowable amount. 0.20 0 0.00 0 0.00 0 0.00 0 0.00 0 HE N14 - Payment based on a contractual amount or agreement, fee schedule, or maximum allowable amount.
1113 52 5583 416 02/10/2007 98943 25.00 0 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 PR Patient Responsibility 185 The rendering provider is not eligible to perform the service billed. 25.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 HE N14 - Payment based on a contractual amount or agreement, fee schedule, or maximum allowable amount.
1114 52 5582 416 02/10/2007 99211 22.00 0 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 CO Contractual Obligations 97 Payment is included in the allowance for another service/procedure. 22.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 HE M144 - Pre-/post-operative care payment is included in the allowance for the surgery/procedure.
1115 52 5581 416 02/10/2007 98942 46.00 21.8 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 CO Contractual Obligations A2 Contractual adjustment. 9.20 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0
1115 52 5581 416 02/10/2007 98942 46.00 21.8 9053 CARTER Processed as Primary FISCHER, MARY ANN R58246471 7047969996000 PR Patient Responsibility 2 Coinsurance Amount. 15.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0

(11 row(s) affected)

Hi,

could you post it in a more readable format, please?

help with my select

I hope this is the right place.

would you folks be kind and point me in the right direction as how i can acomplish this?

here is my proc code.

here is the table that is created.

(11 row(s) affected)

Hi,

could you post it in a more readable format, please?

Help with MSDE Install

Installed MSDE on windowsxp pro.
When computer restarts, icon seen at System Tray.
Click on icon and SQL Server Service Manager.
Server field blank
Services field blank
typed in computername for Server field
select start/continue button.
error message that no service has been selected.
Where did I go wrong?
Walter Wu
Logfile:
2005-06-30 07:26:25.64 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2005-06-30 07:26:25.64 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-06-30 07:26:25.64 server All rights reserved.
2005-06-30 07:26:25.64 server Server Process ID is 540.
2005-06-30 07:26:25.64 server Logging SQL Server messages in file
'G:\MSSQL$MYFIRSTSQLSERVER\LOG\ERRORLOG'.
2005-06-30 07:26:25.67 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2005-06-30 07:26:26.54 server SQL Server configured for thread mode
processing.
2005-06-30 07:26:26.54 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-06-30 07:26:26.70 spid2 Starting up database 'master'.
2005-06-30 07:26:27.07 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-06-30 07:26:27.07 spid5 Starting up database 'model'.
2005-06-30 07:26:27.10 spid2 Server name is 'MASTER\MYFIRSTSQLSERVER'.
2005-06-30 07:26:27.10 spid2 Skipping startup of clean database id 4
2005-06-30 07:26:27.21 server SQL server listening on Shared Memory.
2005-06-30 07:26:27.25 spid5 Clearing tempdb database.
2005-06-30 07:26:27.67 spid5 Starting up database 'tempdb'.
2005-06-30 07:26:27.75 spid2 Recovery complete.
2005-06-30 07:26:27.75 spid2 SQL global counter collection task is
created.
2005-06-30 07:26:28.57 server SQL Server is ready for client connections
"NoOne" <NoOne@.NoName.com> wrote in message
news:%238pclQQfFHA.268@.TK2MSFTNGP15.phx.gbl...
> Installed MSDE on windowsxp pro.
> When computer restarts, icon seen at System Tray.
> Click on icon and SQL Server Service Manager.
> Server field blank
> Services field blank
> typed in computername for Server field
> select start/continue button.
> error message that no service has been selected.
> Where did I go wrong?
>
> Walter Wu
>
|||hi Walter,
NoOne wrote:
> Installed MSDE on windowsxp pro.
> When computer restarts, icon seen at System Tray.
> Click on icon and SQL Server Service Manager.
> Server field blank
> Services field blank
> typed in computername for Server field
> select start/continue button.
> error message that no service has been selected.
> Where did I go wrong?
>
from your log file, your MSDE is runnig... but you probably installed MSDE
without network protocols support, and this unfortunately can cause the
corresponding instance not to show up in the SQL Server Service Manager, as
reported in http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||-
/kj
"NoOne" <NoOne@.NoName.com> wrote in message
news:ekke%23fQfFHA.2384@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Logfile:
> 2005-06-30 07:26:27.10 spid2 Server name is 'MASTER\MYFIRSTSQLSERVER'.
> "NoOne" <NoOne@.NoName.com> wrote in message
> news:%238pclQQfFHA.268@.TK2MSFTNGP15.phx.gbl...
Trying entering
MASTER\MYFIRSTSQLSERVER
on the server line of SQL Server Manager, wait a painfully long time with
the hour glass, and eventually you should see your services state.
Unfortunately, you'll have to do this everytime as it won't stick. ( Don't
you wish you had shortened that instance name now? ;-) )
/kj
|||Change the instance name and removed the password and it works.
Thanks everyone.
"NoOne" <NoOne@.NoName.com> wrote in message
news:ekke%23fQfFHA.2384@.TK2MSFTNGP15.phx.gbl...
> Logfile:
> 2005-06-30 07:26:25.64 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2005-06-30 07:26:25.64 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2005-06-30 07:26:25.64 server All rights reserved.
> 2005-06-30 07:26:25.64 server Server Process ID is 540.
> 2005-06-30 07:26:25.64 server Logging SQL Server messages in file
> 'G:\MSSQL$MYFIRSTSQLSERVER\LOG\ERRORLOG'.
> 2005-06-30 07:26:25.67 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2005-06-30 07:26:26.54 server SQL Server configured for thread mode
> processing.
> 2005-06-30 07:26:26.54 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2005-06-30 07:26:26.70 spid2 Starting up database 'master'.
> 2005-06-30 07:26:27.07 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2005-06-30 07:26:27.07 spid5 Starting up database 'model'.
> 2005-06-30 07:26:27.10 spid2 Server name is 'MASTER\MYFIRSTSQLSERVER'.
> 2005-06-30 07:26:27.10 spid2 Skipping startup of clean database id 4
> 2005-06-30 07:26:27.21 server SQL server listening on Shared Memory.
> 2005-06-30 07:26:27.25 spid5 Clearing tempdb database.
> 2005-06-30 07:26:27.67 spid5 Starting up database 'tempdb'.
> 2005-06-30 07:26:27.75 spid2 Recovery complete.
> 2005-06-30 07:26:27.75 spid2 SQL global counter collection task is
> created.
> 2005-06-30 07:26:28.57 server SQL Server is ready for client
> connections
> "NoOne" <NoOne@.NoName.com> wrote in message
> news:%238pclQQfFHA.268@.TK2MSFTNGP15.phx.gbl...
>

Monday, March 26, 2012

Help with setting up Reporting Services

help with service account permissions

Wednesday, March 21, 2012

help with reporting services

Internet Explorer cannot display the webpage

help with reporting services

Internet Explorer cannot display the webpage

Monday, March 19, 2012

Help with query formatting

Monday, February 27, 2012

help with my select

help with my select

Help with MSDE Install

Max Query

Blog Archive

About Me