Error While Configuring DB Mirrorring

Mar 26, 2008

I am trying to configure DB mirrorring using the SQLCMD & am getting an error :


Msg 1416, Level 16, State 31, Line 1

Database "Test" is not configured for database mirroring.

All the other steps execute perfectly fine.. the endpoints are created properly... & this fails when I try to give a network server addres with the Port No on the Principal ... I have given it first on the Mirror & that runs fine....

Its fails on the Principal .... also .. when I run the DB Mirrorring Wizard it runs fine .. there is no problem ... want to do it via script .. can some one please help...

Thanks






-- Declare variabled for the Principal, Mirror Servers & the DB that needs to be Mirrorred alongwith the backup path.
ETVAR MyPrincipalServer "ServerMY2005"
ETVAR MyMirrorServer "ServerMY2005QA"
ETVAR Database2Mirror "Test"
ETVAR BackupPath "C:"
ETVAR Permit "::[Mirroring]"

-- Create the Endpoints on the Principal & the Mirror Server
:CONNECT $(MyPrincipalServer)
CREATE ENDPOINT [Mirroring]
AS TCP (LISTENER_PORT = 5022)
FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = REQUIRED ALGORITHM RC4)
GO
ALTER ENDPOINT [Mirroring] STATE = STARTED
GO


:CONNECT $(MyMirrorServer)
CREATE ENDPOINT [Mirroring]
AS TCP (LISTENER_PORT = 5023)
FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = REQUIRED ALGORITHM RC4)
GO
ALTER ENDPOINT [Mirroring] STATE = STARTED
GO

-- COnnect to the Principal & Set Recvery Model & Take FUll Backup of the DB
:CONNECT $(MyPrincipalServer)
GRANT CONNECT ON ENDPOINT $(PERMIT) TO [ServiceAccount]
go
ALTER DATABASE $(Database2Mirror)
SET RECOVERY FULL
GO
CHECKPOINT
GO
BACKUP DATABASE $(Database2Mirror)
TO DISK = '$(BackupPath)$(Database2Mirror).bak'
WITH INIT
GO

-- Restoring the Backup file to the Mirror Server with NORECOVERY Need to take care of the With MOVE Option.
:CONNECT $(MyMirrorServer)
GRANT CONNECT ON ENDPOINT $(PERMIT) TO [ServiceAccount]
go
RESTORE DATABASE $(Database2Mirror)
FROM DISK = '$(BackupPath)$(Database2Mirror).bak'
with norecovery,
move 'Test' to 'C:Test.mdf',
move 'Test_log' to 'c:Test.ldf'
GO



:CONNECT $(MyPrincipalServer)
BACKUP Log $(Database2Mirror)
TO DISK = '$(BackupPath)$(Database2Mirror).Trn'
GO

-- Restoring the Backup file to the Mirror Server with NORECOVERY Need to take care of the With MOVE Option.
:CONNECT $(MyMirrorServer)
RESTORE Log $(Database2Mirror)
FROM DISK = '$(BackupPath)$(Database2Mirror).Trn'
with norecovery
--move 'MyTestDB' to 'C:mytesdb.mdf',
--move 'MytestDB_log' to 'c:mytestdb.ldg'
GO


-- Specify Server Network Address
:CONNECT $(MyMirrorServer)
Use Master
go
ALTER DATABASE $(Database2Mirror)
SET PARTNER = 'TCP://136.50.85.60:5022'



:CONNECT $(MyPrincipalServer)
Use Master
go
ALTER DATABASE $(Database2Mirror)
SET PARTNER = 'TCP://136.50.85.60:5023'

View 2 Replies


ADVERTISEMENT

Error While Configuring

Mar 28, 2007



While configuring reporting services, in the database setup section, I am entering the instance name connecting to, and the user-id details. On applying the changes, i am getting an error that "Using other edition of database for reporting data sources and/or report server databases is not allowed in this version of Reporting services"



Can anyone help me resolve this issue?



Thanks,

Vijay

View 5 Replies View Related

Error While Configuring XML Support In IIS With IIS 6.0

Dec 22, 2003

Hi,

I've two servers on which there is the SQL 2000 Server and the IIS 6.0.

I installed the SQL Server Client Tools on web server.

And created the nwind as told in booksonline.

I declared the SQLXML extention and allowed it using IIS 6.

But there is a problem with the virtual directory I created using the tool "Configure XML Support in IIS". Web server doesn't realize it as a virtual directory. Even a jpg or a text file is not served by the IIS.

The web server shows the following error.


ERROR: 500 Internal Server Error
HResult: 0x800706f4
Source: Microsoft SQL isapi extension
Description: Invalid virtual root settings



Thanks for any suggestions.

View 2 Replies View Related

Error While Configuring Database Mirroring

Dec 18, 2007

Hi all,

I am trying to set up Database mirroring on my test & DR server. But , I am getting the following Error:
( On local PC Mirroring is successful).

Both the test & DR have same service accounts for SQL Server.

Thanks for all your help.

Thanks.

Error:
TITLE: Database Properties
------------------------------

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'databasename'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server network address "TCP://Mirrorserver.domainname.local:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

View 3 Replies View Related

Reporting Services Configuring Default Error Messages

Aug 8, 2007

I have searched the web and have not had any luck on finding the issue to my problem. I'm sure it's probably simple, so here it goes.

When receiving the following error "The permissions granted to user '' are insufficient for performing this operation"

Now, I would like to add to the error message shown above an extra line below it on the web page to reflect something like "Please contact XXX @ XXX if you feel that you need to have your login issue resolved" ...or something meaningful in addition to the default error messages.

I am not getting this error normally, as I have made a typo when login in on purpose! I am just trying to find a way to add more detail to the current error message or change the message to what I want it to say. This would go for any error message received by an end user received through SQL Server 2005 Reporting Services.

Do I have to create some sort of filter to read the message coming back from within SOAP? Are these messages stored in ReportingServices database or htm file?

Thanks!
ICE

View 4 Replies View Related

Programmatically Configuring Error And Truncation Dispositions For Row Redirection

Mar 29, 2007

Hi,



I have created a SSIS package programmatically using C#.



The package should do the following take data from source A, and place rows into destination B, if there are any error rows then redirect the rows to destination C. In my package I have the following components:



DTSAdapter.OLEDBSource.1 - Used as the Source

DTSAdapter.OLEDBDestination.1 - Used for the Destination Output - (let me call this normalOutput)

DTSAdapter.OLEDBDestination.1 - Used for the Destination Error Output - (let me call this errorOutput)



All my mappings appear to be correct, I build and save the package and receive a Successful validation and Success on Execution.



However, When I open the application using the Execute Package Utility I get the warning:



Warning:No rows will be sent to the error output(s). Configure error or truncation dispositions to redirect rows to the error output(s), or delete data flow transformations or destinations that are attached to the error output(s)



How do I get around this?







I have placed on the DTSAdapter.OLEDBDestination.1 (Used for the Destination Output), on the input collection I have placed:



normalOutput.InputCollection[0].ErrorRowDisposition = DTSRowDisposition.RD_RedirectRow;

normalOutput.InputCollection[0].TruncationRowDisposition = DTSRowDisposition.RD_RedirectRow;

normalOutput.OutputCollection[0].ExclusionGroup = 1;



on the DTSAdapter.OLEDBDestination.1 (Used for the Destination Error Output) I have placed:

errorOutput.OutputCollection[0].ExclusionGroup = 1;



However this does not work, I just get the wanring displayed above.







I have also tried to set the

OutputCollection[0].SynchronousInputID for both the error output and the normal output to the same values

so that:

normalOutput.OutputCollection[0].SynchronousInputID = normalOutput.InputCollection[0].ID

errorOutput.OutputCollection[0].SynchronousInputID = normalOutput.InputCollection[0].ID



However, the above scenario does not pass the package validation, in the Execute Package Utiltity, I get the wanring mentioned above and also the error:

Error: The input "OLE DB Destination Input" (16) has an invalid error or truncation row disposition.







So my question is what are the correct configuration settings to have in this scenario?



Thanks





View 15 Replies View Related

Getting Report Server WMI Provider Error: Not Found While Configuring Reporting Sevices Integration WSS 3.0 And Sql 2005

Jan 29, 2007

I'm Getting "Report Server WMI Provider error: Not Found" when trying to Grant Database Access while configuring the Reporting Sevices Integration. Logging in fine to the DB. Tried all the WMI troublshooting and can't find any issues there. Any tips?



Many Thanks!!

View 10 Replies View Related

Configuring 2GB RAM For SQL

Oct 30, 1998

Dear all

Problem and symptoms

We have recently added 1GB Ram to our systems and now we are trying to optimally configure 2GB of RAM for SS6.5 SP4 and we are getting the fllowing error INFREQUENTLY

"Not enough memory for pss allocation"

We have to restart the SQL server/ (recover databases) to get out of this. Since it is a heavily loaded production environment you can imagine the impact!!.

SPECS

OS-- NT4/sp3
H/W -- Dual Processor Alpha 4100
MEM -- 2GB
SQL PArameters:
memory--819200
Worker Threads -- 255
Proc cache -- 12%

Work done so far

There is a recommendation to reduce the memory or stack size parameters ref:Q160683!!

Question

1. I would like to know if anyone has got around a similar problem, and how. 2. As in NT Virtual Memory Manager AUTOMATICALLY brokers the allocation of physical memory between the requesting applications (e.g. sqlsrvr.exe) and the page file and no application can write directly to RAM, what does the memory parameter in SQL config control? Also then how is the above KB article relevant?

I look forward to your response

Thanks and regards

Arun

View 3 Replies View Related

Configuring SQL Cache

Apr 25, 2007

Hi all,
     I have a question regarding SQL caching.
     I want to use SQL caching for my pages.I've gone through http://msdn2.microsoft.com/en-us/library/e3w8402y(VS.80).aspx article on msdn, where in step by step procedure is explained for this. But I have a slightly different situation. In the article, we need to configure our application from web.config by following...
<!-- caching section group --><caching>  <sqlCacheDependency enabled = "true" pollTime = "1000" >    <databases>      <add name="Northwind"          connectionStringName="NorthwindConnectionString1"         pollTime = "1000"      />    </databases>  </sqlCacheDependency></caching>
 
Where in "NorthwindConnectionString1" is the SQLdatasource connection string. But I'm not using SQLDatasource, and have my own classes to build a connection datasource and get a dataset, and then bind it to my control.So in this case what should I write for the above "connectionstring"  attribute. My connection string is in web.config only with a section defined. and in my application i'm reading from web.fing only.The connection section i'm using is as follows...
<ConnSettings>
<add key="ConnString" value="server=serverName;database=dbName;uid=dbuser;Pwd=password"/>
</ConnSettings>
I want to know how to configure my sql cache in this situation.
 
Thanks,
Mehul Mistry

View 2 Replies View Related

Configuring SQL Datasource

May 29, 2008

Hi
When I try to configure a SQL datasource and I use a Microsoft SQL Server datasource I get a blank drop down list for server name.  My aspnetdb is available in SQL Server 2005 and I can log into it through management studio, and the service is started.  I am also using Vista Ultimate.
Is there any other configuration I need to do for Visual Studio 2008 to see the SQL Server instance?
Thanks
 Kwis

View 2 Replies View Related

Configuring SQL Mail - Help Please

Jun 18, 2001

Hi all,
I want to configure my SQL mail. I am able to configure SQL mail when i run the SQLAgent and SQL Server services under domain account for which Mail box was created in MS Exchange server. Also it works fine. But i want to Configure SQL mail without using Domain account (dont want to run services under domain account due to security reasons).

Anybody know how to Configure SQL mail without using domain account or is it possible to configure like that? Your suggestions are highly appreciated.
thanks in advance.
regards..

View 5 Replies View Related

Configuring SSRS On Win XP

Apr 4, 2008

Hi All,

I am fairly new to SSRS. I want to install SSRS on my local system which has OS of Win XP sp2 (not a server). I have installed SQL Server instance on this box. Can any body tell if i need Win Server 2000 or 2003 OS to install SSRS or can i use Win XP, if so please give some guidelines.

Thank's in advance..

View 2 Replies View Related

Configuring User In SQL

Sep 26, 2007

I new to SQL 2005 and have couple of questions regarding configuring the user. Let me start by saying what I need to be achieved.

1. Create a new user which will be user by couple of people to create and execute stored procedures
2. Deny all permissions for this user to access data from certain tables.
3. Configure the role and permissions for this user so that the above two is possible.


I was able to do the first two steps and when the users uses a query, ( select * from 'that table' ) the result in a permissions error. Also that user cannot view the table in SQL manager

The problem now is that that user can create a stored procedure that has the SQL statement Select * from 'that table' and execute the stored procedure to view the table.

The reason I created this user is to allow a team in the company to create stored procedures for Crystal. In theory he should be able to create stored procedures but not get any data from the denied tables. How can I achieve this?

I am trying to resolve this issue for a while now and any help is greatly appreciated.

Regards,

View 7 Replies View Related

Configuring SQL MAIL

Aug 4, 2005

Hi All,My question is that can I configure SQL MAIL, if my EXCHANGESERVER is on different domain and my SQL is running on differentdomain.Can anyone guide me for this because I googled a lotwithout any result.I am using SQL SERVER 2000 Enterprise Edition with service pack 3.and MICROSOFT EXCHANGE SERVER 2000.ThanksT.V

View 1 Replies View Related

Configuring SQL With Sp_configure

Jan 7, 2008


Can someone help? I am new to Visual basic programming and have down-loaded Visual Basic Express. I followed the instructions for creating my first database but when I got to making the SQL database I got the following error message. " Generating user instances in SQL server is disabled, use sp_configure "user instances enabled" to generate user instances" Where do I find sp_configure and how do I start it.

View 1 Replies View Related

SQL Mail - Configuring

Sep 27, 2006

wasnt sure which forum to put this in - so i'll attempt here!

i have been trying to setup SQLMail in SQL2000 but have been having a few problems

i have created an Outlook MAPI profile for SQL to use. i have tested the profile and it is sending emails - the profile was created using the correct user which has local admin privileges and also a domain account 

i then assigned this profile to SQLMail within Enterprise manager and clicked Test. this completed successfully stating it was able to start & stop a MAPI session.

so i assumed that was all thats needed??

through Query Analyzer i run a simple test

EXEC xp_sendmail 'Craig.Gamble@<mydomain>.com' 'The DB is full'

i get a success message saying SQL mail sent. but it doesnt appear to send anything? i never recieve anything. The sent items does not contain anything and even when checking the actual Exchange server there is no sign of any mail being sent

i also checked the SQL account permissions to make sure it could access the Exchange Server using the

EXEC xp_cmdshell 'NET USE \EnterpriseIPC$' and again this returned success

so now im stumped!

is there anything else i can check to see where or what its supposedly sending??

any help greatly appreciated.
Cheers,
Craig

View 1 Replies View Related

Configuring Roles/Membership SQL To Not Use DBO?

Aug 26, 2006

I have a site with roles/membership working fine on my local machine, but I am having serious trouble deploying it to a shared host.  My hosting provides a sql 2000 database, but the user created for it that I use is not dbo.  I am errors when I try to access my site such as Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'The procedure was created under my user, so it's there, but it's full name ia myusername.aspnet_CheckSchemaVersionHow can I tell the asp.net membership/role provider to use my username instead of dbo when it looks for objects? Thanks   

View 6 Replies View Related

Configuring SqlDataSource At Runtime

Oct 31, 2007

In a web site the user has to choose one out of several sql tables to deal with.
He will then be allowed to view the selected table data through a GridView, to insert a new row into and to update a row in the selected table by means of an array of TextBoxes created dynamically on the base of the selected table.
I think it is possible to solve the problem fully by properly configuring at run time an SqlDataSource.
I have solved the issue of data display by declaring in the code behind within the OnPageLoad sub the following:
SqlDataSource1.SelectCommand = "Select * FROM " & selectedTable
While for the  GridView1 I have added the selected table columns to the columns collection as follows:
for i=0 to ColumnCount-1 Dim cac As BoundField = New BoundField
cac.HeaderText = HeaderNamesArray(i)
cac.DataField = ProductNamesArray(i)Me.GridView1.Columns.Add(cac)
next
I have difficulty on how to do similar declarations for the insertcommand and update command.

View 2 Replies View Related

Configuring Dynamically An SqlDataSource

Jan 4, 2008

I have several Sql Tables, each containing more than 100 fields, on which I need to perform display operation through GridView, Insert and Update through an array of dynamically created and databound TextBoxes.
I would like to use a single page to manage all Sql Tables on the basis of the name of the specific one invoked by the user.
In order to achieve that, I need to  dynamically configure the SqlDataSource Web Control present on the page for each Sql Table. In particular I need to generate at runtime the InsertCommand and the UpdateCommand.
On how to do it I have no idea.
Federico

View 2 Replies View Related

Urgent Configuring Sql Server

May 29, 2008

hi all i try all date convertion  function that u imagen   in my asp.net project to insert a date  to sqlserver datetime field but always sql server get the data as "1/1/1900 00:00:00"
how can i fix that from sql server
plz

View 8 Replies View Related

Configuring A SQLDatasource Control

Feb 26, 2006

When I configure a SQLDataSource control I want the following where clause...
WHERE     (RegionID = @RegionID AND DistrictID IS NULL AND CampusID IS NULL) OR (DistrictID = @DistrictID AND CampusID IS NULL ) OR(CampusID = @CampusID AND UserRole = 'CampusAdmin') OR (CampusID = @CampusID)but it gets reformated as....
WHERE     (RegionID = 'Region10') AND (DistrictID IS NULL) AND (CampusID IS NULL) OR                      (DistrictID = 2) AND (CampusID IS NULL) OR (CampusID = '999999103') AND (UserRole = 'CampusAdmin') OR                       (CampusID = '999999103')I don't think these are functionaly equivelant, are they?If not how do I stop the 'wizard' from reformatting the SQL where clause?Thanks

View 3 Replies View Related

Problem Configuring Workstation

Apr 14, 1999

How can I configure my workstation running WIN95 to used the SQL Enterprise Manager from the server end and other utilities. I have installed the client network utility.

Reason to use enterprise manager because I wanted to perform administrative tasks on my workstation and I've installed SQL SERVER 7.0(Standard version with 5 clients)on the WINNT 4.0 server.


Can anyone helps?

View 1 Replies View Related

Configuring DISK Sub System

Mar 2, 2006

Hi all,

Need some help with configuring the Disk Sub system using Raid 10

1. What shud be the disk configuration to have 4000 inserts per second on a RAID 1+0 ?
2. What is the best way to maintain a Hot Stand by Server for a very high OLTP system ( say for a day Trading Database ).


Thx
Venu

View 3 Replies View Related

Configuring SQL Database To Access It From Web DB

Jul 7, 2007

hi,

I need to connect my Local Database from SQL Server to the Web Database.
I need to know what all things to be done for completing this process. Some one please please help me with this.

Ad if this information is not enough, please do ask me any question regarding this and iam ready to answer them.

One more thing, iam not that familiar with SQL Server 2000 but i can manage to do things.

So please do help me on this.



Clever_Idiot

View 4 Replies View Related

Configuring Locks In Awe System

Jul 20, 2005

I am running Microsoft SQL Server 2000 - 8.00.760 Enterprise Editionon Windows 2003 Enterprise Edition (NT 5.2 Build 3790:) I have 4CPUand 8GB of RAM. I have AWE enabled, /pae /3gb switch is on inboot.ini, In my errorlog I have noticed few times error messages as"The SQL Server cannot obtain a LOCK resource at this time. Rerun yourstatement when there are fewer active users or ask the systemadministrator to check the SQL Server lock and memory configuration.." I haven't modified anything in sp_configure 'locks', so i amassuming SQL server is dynamically managing the lock memory. Runningperfmon for few days I observed that Lock Requests/sec are usually few100,000 most of the times and sometimes goes to 2+ million. However Ihaven't seen Lock Memory (KB) going more than 40MB. So i wonder why amI seeing the Error: 1204 in my sql log ? And any advise on how toprevent it.ThanksAswinee

View 1 Replies View Related

Configuring A Database In Sqlserver?

Jun 9, 2006

I am learning dotnet thru Microsoft Official Curriculum and I got stuck up at one point. That is I couldn't configure the required databases according to the sql server I have installed and configured. I created a doctors database and while configuring using the below code I couldn't know what is 'ASPNET' in "SELECT @s = @@servername + 'ASPNET'"
Also what is 'webuser'



---Configure Doctors
USE doctors

GO

DECLARE @s varchar(50)
SELECT @s = @@servername + 'ASPNET'
EXECUTE sp_grantlogin @s

EXECUTE sp_grantdbaccess @s, 'webuser'

GO

GRANT EXECUTE ON [getUniqueCities] TO webuser
GRANT EXECUTE ON [getDrSpecialty] TO webuser


GRANT SELECT ON [specialties] TO webuser
GRANT SELECT ON [doctors] TO webuser
GRANT SELECT ON [drspecialties] TO webuser

GO


Can anyone help me how to solve my problem?
Your help would be very much appreciated

Thanks and Regards

Kavitha

View 1 Replies View Related

Configuring Sql Express On Installation

Nov 10, 2006

Can someone explain to me what SQLACCOUNT=<domainuser> is or should be set to? I get an error telling me to specify a built in account or give a username domain and password for each service. How do I specify these things I didnt see those in the 1 msdn page that explains this. I asked this before but I still cant figure it out. Thanks.

View 1 Replies View Related

Need Help Configuring SQL Server Express

May 11, 2007

I have Visual Studio 2005 Professional installed and SQL Server Express installed. In following along with the Microsoft Visual C# Step by Step book, there is a procedure on page xxi to get access to SQL Server Express. At the 2> prompt, however, when I type in go and then press enter, I get the following message:



Msg 15247 Level 16, State 1, Server MyServerNameSQLEXPRESS, Procedure sp_grantlogin, Line 13



User does not have permission to perform this action.



The computer is my own personal computer, with Window Vista installed and no previous versions of MSDE installed. I also have administrator persmissions. The only guidelines in the procedure regarding what to do in the event of an error message is to ensure that the commands were typed in correctly. What could be causing this message, since I do have administrator permissions?

View 9 Replies View Related

Configuring Environment For First Time

Feb 8, 2006

Each time I start of SQL Server Management Studio, I get the following message "Microsoft SQL Server Management Studio configuring environment for first time".

I had a simiiliar message with Visual Studio 2005 and fixed it by setting the setting to look on local disk drive. I cannot find a similiar setting in SQL Server 2005.

Any suggestions on how to resolve?

View 4 Replies View Related

Configuring 2 Nodes As Failovers For Each Other

Mar 22, 2007

We have a number of databases in our company and we recently had to buy a second SQL server. What I would like to do is have both SQL Servers act as failovers for each other. They both are the exact same hardware configuration (dell blades poweredge 1855) and we have a RAID array with Melio clustered file system for our web servers. I haven€™t found any documentation on if this is even possible. Am I completely wrong in thinking this can be done or is there a better solution to spread the load but provide failover support with out buying 2 new machines?

View 1 Replies View Related

Configuring Dataset Dynamically

Apr 16, 2007

HI ,



I am using SQL Server 2005 Reporting Services. I have many parameters to pass to the dataset. Is there a way to change the dataset dynamically based on the parameters selected?



Suppose If param1 is selected, I want to use dataset1 and if param 2 is selected. I want to use dataset2 and so on... in my reports.



Any help is greately appreicated!



Thanks in advance!

View 8 Replies View Related

Problem In Configuring ASPState DB For .NET 2.0

May 16, 2007

Hi,

In the current production environment we have web applications running in asp.net 1.1 (win 2003 server) which uses ASPState DB for the session management. We are in the process of migrating few of the web application in asp.net 2.0. We would like to use the same ASPState DB for both 1.1 and 2.0 applications for maintaining the session.

Problem that we are facing: After going through couple of article for configuring the ASPState DB, We ran the InstallPersistSqlState.sql of .net 2.0 framework (log information is given below). Though the sql has updated the existing ASPState DB with the stored procedure corresponding to asp.net 2.0, still we get the following error

Exception: System.Web.HttpException
Message: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.

For certain reasons, we are not able to use aspnetreg_sql.exe for setting up the ASPState database. Is there something that I am missing when I run InstallPersistSqlState.sql alone.



Appreciate your help.



Thanks,

Siva



PS: We ran the InstallPersistSqlState.sql in the local sqlserver2000 (residing in winxp) and it works fine.



Result Log:


Run 'aspnet_regsql.exe -?' for details.
--------------------------------------------------

---------------------------------------------------
Completed execution of UninstallPersistSqlState.SQL
---------------------------------------------------


------------------------------------------------
Starting execution of InstallPersistSqlState.SQL
------------------------------------------------

--------------------------------------------------
Note:
This file is included for backward compatibility
only. You should use aspnet_regsql.exe to install
and uninstall SQL session state.

Run 'aspnet_regsql.exe -?' for details.
--------------------------------------------------
The CREATE DATABASE process is allocating 0.63 MB on disk 'ASPState'.
The CREATE DATABASE process is allocating 0.49 MB on disk 'ASPState_log'.
If the job does not exist, an error from msdb.dbo.sp_delete_job is expected.
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61
The specified @job_name ('ASPState_Job_DeleteExpiredSessions') does not exist.

(1 row(s) affected)

Type added.

(1 row(s) affected)

Type added.

(1 row(s) affected)

Type added.

(1 row(s) affected)

Type added.

(1 row(s) affected)

Type added.
If the category already exists, an error from msdb.dbo.sp_add_category is expected.
Server: Msg 14261, Level 16, State 1, Procedure sp_add_category, Line 32
The specified @name ('[Uncategorized (Local)]') already exists.

-------------------------------------------------
Completed execution of InstallPersistSqlState.SQL
-------------------------------------------------

View 3 Replies View Related

Configuring Reporting Services

Apr 26, 2007

Hello Experts,



I have this problem when i go to http://<servername>/reprots



"The attempt to connect to the report server failed.Check your connection information and that the report server is a compatible "



I dont have any problem viewing the deployed reports from the site, http://<servername>/reportserver. only issue is in viewing report manager.



i have searched the forums and did all the suggested changes required in the config file, by adding the full report url and removing the entries in the virtualdirectory tag. still it didnt help....



would be great if someone suggests.



regards,

lakshman.









View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved