Web Application Will Not Function After Being Published (database Problem)

Jun 27, 2006

Hello everybody,

Here is the case:

1 €“ When I make a web application with VS 2005 (on a Windows XP Pro SP 2 machine) using a database (with the included SQL 2005 Express) all works fine on my dev computer

2 €“ After publishing that application on my Web server (an old but fresh reformatted machine with Windows 2000 Server SP 4 - but without any special feature of server version such as active directory configured -, IIS 5, SQL 2005 Express SP 1 with Advance Services, both 1.1 and 2.0 frameworks installed on it). I have this error when I call the application from IE:

(Be kind as all my configuration and error messages are in French so I try to translate them the best I can but if translation is not clear tell me €“ and if someone knows how I can have those messages in English tell me also ;-)

Open session failure for user [my web server name]ASPNET

 

For information I have done/try all the following (and probably more; don€™t remember as I am stuck on this since nearly 2 weeks now ) without success:

- changing the SQL Server surface area exposition to remote connections for TCP/IP, named pipes and both (in fact even when the exposition is set to local I still have the same error€¦)

- adding a [my web server name]ASPNET account with dbo/sysadmin rights with SQL Server Management Studio Express, as well as other special accounts (IUSR and IWAM)

- manually attaching database under SQL Server Management Studio Express and mapping the above accounts to it (and of course modifying the ConnectionString settings in the web.config file accordingly)

- same thing with those 3 accounts but this time for folder and subfolders with full control rights

- publishing my web application with both Publish Site and Copy Site options from VS 2005 (which seem to do exactly the same thing). I am using the Remote site connection option (the one where you need to enter the IP address of the web site and have FrontPage extensions installed on it)

- and all other stuff as mentioned in an earlier post on this matter (http://forums.microsoft.com/msdn/ShowPost.aspx?postid=505487&isthread=false&siteid=1&authhash=7399dc0a380f8452fd1aa40f4b530be62a7a8e70&ticks=632868985326044888)

I can give any complementary information such as error stack trace or web.config file if needed to help me.

For information, I have an older web application running (perfectly) on this server. This one was done with VS 2002/framework 1.0/SQL Server 7.0 database and is now running with framework 1.1/SQL Server 2005 Express on the server. I thought at first that application would be the one to give me headaches as the database was from an older version of SQL Server but I simply attached the .mdf file under SQL Server Management Studio Express and all worked perfectly and immediately€¦

I am not too bad in development but I must confess I am quite a noob as Windows/IIS/SQL server/network administrator so I really need a help on this as I am stuck since nearly 2 weeks and I think I won€™t have many hair left on my head if I don€™t find quickly a solution to that problem.

Thanks in advance.
DreamingBear (in fact NightmareBear would actually sounds better )

View 9 Replies


ADVERTISEMENT

My Published Application Can't Access The Database

Jun 8, 2007

Hi

I am nearing the end of creating my Windows App for work. So I tried to publish it, that was fine until I ran the app, from the same PC as I use to develop, with the same login etc. However when I use the published app I can't connect, to the database, return to VS2005 and run my app from within there and no problems. It is SQLEXPRESS (SQL Server 2005), but I have checked the settings there are correct (I assume VS wouldn't connect otherwise).

Help please.

Details...

Server = FRED database =Joe

Connection string (Data Source=FREDSQLEXPRESS;Initial Catalog=JOE;Integrated Security=True

Server (Win2003) and my PC (Win2K) are on the same domain

Using TCP/IP

I can't see how to enable JiT debugging despite the 'help' at the end of this error details...
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at TrainTrack.frmAddCompetency.frmAddCompetency_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
TrainTrack
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/graham.yetton/Local%20Settings/Apps/2.0/4GZWZKGB.4O3/9XXGWKLB.MTQ/trai..tion_75116344273b6719_0001.0000_b44ce39f580948f8/TrainTrack.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

View 4 Replies View Related

Retrieve Fields List From A Published Report Data Model Published On The Reporting Server.

Jul 17, 2007

Can someone please tell me how to retrieve/query the list of fields from an entity of a report data model that has been published on the reporting server programmatically ?

I am trying to upload a report data model to the reporting server and planning to use that model as the data source and consume it through our existing web application?

Thank you ,

Rashid A. Khan

View 1 Replies View Related

Can Not Login My Database When Published To IIS

May 14, 2007

hi,



i am tring to use the 'xcopy' way to deploy my web site, this is the connection string i am using:

"Data Source=.SQLEXPRESS;INITIAL CATALOG=;AttachDbFilename='|DataDirectory|HotStage.mdf';Integrated Security=True;User Instance=True"



it works when in debug mode, but after i depoly it to my XP's IIS, it can not login the database, the error message is :

Cannot Login to the default user database. Login Failed. Login Failed for user xxxASPNET

'xxx' is my computer.

i think this problem is cause of improper setting of security, but i really do not know how to set it in this situation, because the database is attached to the db system dynamically.



plz someone help, thx

View 3 Replies View Related

SQL Express Database In Published Web Site

Mar 26, 2007

I have been working with Visual Studio 2005 and the Personal Web Site Starter Kit. All is well and working. My problem is that after the database is updated (as in uploading photos and album creation) and the original web site is edited and republished, the web site database is overwritten and all the work is lost. What is the proceedure to either copy the web database to the development site on my computer so updates will not be lost, or a method of publishing that will not loose the up to date content on the web server? I would much prefer to be able to copy the database to my development computer as adding tables to the database is something that needs to be done. Any help on this would be appreciated.



Thanks

View 3 Replies View Related

Database Connection On My WebSite ,I Published On Internet.

Nov 9, 2007

I create a WebSite onto the internet.
Then I created a database with MSSQLmanager provided by the WebHosting.
I created a Table and put some data in it.
When I try to access the DataBase an Error says: "Connection cannot be opened. On default settings you cannot access a Database Remotely."
What shall I do to configure my Database.
basically I don't know where to go to change configuration of my Database.
In my intranet I would use SQLServerSuraceArea.
But on Internet I do not know.
someone Help.
Did I miss something ?

View 4 Replies View Related

Access SQL Server 2005 Database Using A Published Website

Jun 26, 2006

Hi all,
 I am stuck with a problem using ASP.Net website. I created a website which accesses a database table in SQL Server 2005. The default.aspx is a form which inserts/updates/deletes data from the database. After creating the website I published it to IIS (Inetpub -> wwwroot). When I use Visual Studio 2005 and build the website and start with debugging. the form comes up and i can insert/update or delete the data from the table as I want. Now, as I have the website published I can access the form from another sharepoint website using the url as
/Employee_Data/Default.aspx">http://<mydesktop>/Employee_Data/Default.aspx
the form shows up but I am not able to access any of the database. I do not see any errors either. Once I click on the button the page just refreshes but nothing else happens. I have my web.config as :-
<?xml version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings/>
<system.web>
<compilation debug="true"/>
<authentication mode="Windows"/>
</system.web>
</configuration>
 
Am I missing something? I even have Anonymous access in the IIS inetpub properties. I can even the database as I am the administrator..... I appreciate your suggestions.
 
Thanks,
Kavya

View 1 Replies View Related

Crash In MFC Application In ConnectTransact Function Of DBNMPNTW.DLL

May 14, 2008

My MFC Desktop application has connection to SQL server (in another server) using Named pipe. Some time (it may be atleast once in a day), I'm getting crash in the MFC applicaton, which has the following stack trace.







11:18:25 Unhandled Exception: Exception code: C0000005 ACCESS_VIOLATION

Fault address: 7331293E 01:0000193E C:icminDBNMPNTW.DLL



Call stack:

Address Frame

7331293E 013D68DC ConnectionTransact+1AE


The SQL Version is SQL Server 2000 with SP4.

Since the stack trace is not giving any point of crash in the MFC application, its very difficult to trace what caused the issue in the application. One of the search result in the google shows, it might be because of the network glitch which causes some security issues in the implementation of the Default Named Pipe. We are using DBLib library for the SQL operations. The SQL clinet and SQL server protocol order is - first Named Pipe and then TCP/IP.

I couldn't figure out the reason of the crash yet. If any one could shed light on this, it would be great.

View 5 Replies View Related

ROW_NUMBER() Function Is Not Recognized In Store Procedure.(how To Add ROW_NUMBER() Function Into SQL SERVER 2005 DataBase Library )

Feb 4, 2008

Can anybody know ,how can we add  builtin functions(ROW_NUMBER()) of Sql Server 2005  into database library.
I get this error when i used into storeprocedure :
ROW_NUMBER() function is not recognized in store procedure.
i used MS SQL SERVER 2005 , so i think "ROW_FUNCTION()" is not in MS SQL SERVER 2005 database library.
I need to add that function into MS SQL SERVER 2005 database library.
Can anbody know how we can add that function into MS SQL SERVER 2005 database library?
 

View 4 Replies View Related

More Efficient Way Than You Have Published

Dec 8, 2004

Sumanesh writes "Recently I read one article “Converting Multiple Rows into a CSV string�

(http://www.sqlteam.com/item.asp?ItemID=256)

I have found one easy and more efficient way to achieve the same thing.
First I have a table called test with 2 columns (ID and Data)
And some data inserted into it.

CREATE FUNCTION [dbo].CombineData(@ID SMALLINT)
RETURNS VARCHAR(2000)
AS
BEGIN
DECLARE @Data VARCHAR(2000)

SET @Data = ''
SELECT @Data = @Data + Data + ',' FROM Test WHERE ID = @ID
RETURN LEFT(@Data,LEN(@Data)-1)

END
GO

Then used a simple select query to achieve the same

SELECT DISTINCT ID, [dbo].CombineData(ID) FROM Test

Which achieved the same thing without using any temporary tables and Cursors. I am sure that you will accept that this is more efficient than the one that has been published.


Thanks
Sumanesh"

View 1 Replies View Related

Cannot Connect From Published Site To My DB

Apr 17, 2007

I'm getting the following error:An error has occurred while establishing a connection
to the server. When connecting to SQL Server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26
- Error Locating Server/Instance Specified) Here's the setup: I have a website I've published on my server, but I haven't moved the SQL DB over to the server. For some reason the testing server can't connect with sql express on my computer. I have named pipes, tcp/ip both on, connections string is "Data Source=AMBA-176SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI"When I'm simply testing the site locally in visual studio it can connect just fine. 

View 1 Replies View Related

Altering A Published Table

Feb 12, 2004

Hi! I've added a column to a published table in the Publisher using SP_REPLADDCOLUMN. After doing this the replication triggers for that table(i.e. del_%,upd_%,ins_%) are doubled both at the Publisher and at the Subscriber. If i update anyone of the column in the table at the Subscriber; i get the following error:

Server: Msg 208, Level 16, State 1, Procedure upd_3E6DE124B82D42A5AEB169557C0D757C, Line 60
Invalid object name 'ctsv_3E6DE124B82D42A5AEB169557C0D757C'.

Any ideas, what has gone wrong????

I have the following SQL setup.
Publisher: Enterprise Edition, SP3.
Subscriber: Standard-Edition, SP3.
The error is at the Subscriber.

View 5 Replies View Related

Published SQL Server Not Showing In AD

Aug 26, 2005

I've been unable to determine why several published instances of my SQL Servers are not showing in AD. I searched under the Computer container in the domain in which the SQL Server was installed and did not see any SQL Server folder. I have used both the GUI and T-SQL to publish various instances, and it appeared to have worked since from the GUI the "Publish" option no longer worked and I recieved no error from Query Analyzer after issuing the command. The version is SQL Server 2000 8.0 running SP3a.

I also ran a VBScript to query the directory for published instances of SQL server, but did not get any results returned in the recordset. Any ideas?

Thanks in advance to anyone that can help.

nu_dba

View 1 Replies View Related

Transforming Published Data

Jan 4, 2006

Hi,

I have read that the old method of using DTS to transform data during replication will not be supported in 2005.

In SQL Server 2005, is there a way to use an SSIS package to modify data you want to replicate?

View 4 Replies View Related

How To Bring Down A Published Report?

Mar 16, 2008

I published a report in SSRS 2005. I see the report on the SSRS home page. How do I remove the report from server and from the home page?

View 3 Replies View Related

CAN NOT DROP TABLE Xxx BECAUSE IT IS PUBLISHED FOR REPLICATION

May 5, 2000

Good morning folks,
I'm getting the above error message when trying to drop a table. I'm not to familiar with the setup of this SQL server, so I not sure if the replication is enabled. I have never had to use replication so I don't know to much about it. Does anyone know how I guess to remove this table from the replication list so that it could be dropped?

Thanks much

Dom

View 1 Replies View Related

Changing The DATATYPE Of A PUBLISHED COLUMN

Oct 27, 2003

Hi guys,

Is there any way or method to CHANGE the DATATYPE of a column in a published table being used for transactional replication (MSSQL 2000), WITHOUT DROPPING THE SUBSCRIPTION ????

Im stuck in this mess and do have the option to drop the subscription, alter the table, create the subscription and rerun the snapshot or to recreate it by Manual Synchronisation either.

Can anyone help? Has anyone been across this dilemma before and have troubleshooted the problem? If yes, help is much appreciated.


MY PROBLEM:
~~~~~~~~~~~~~
'MyTable' is currently being published and has subscriptions to it. The PRIMARY KEY column 'id' has an Identity property as well. 'id' is of datatype smallint, however because of bad planning, i now need to change that datatype to an integer to support a larger range WITHOUT DROPPING SUBSCRIPTIONS.
I CANT DROP THE COLUMN EITHER AS IT IS BEING THE PRIMARY KEY COLUMN.

IS THERE ANY OTHER WAY I CAN DO TO ARCHIEVE MY GOAL? THANKYOU.

View 3 Replies View Related

Cannot Alter Table Being Published For Replication

Jun 8, 2006

Hi all,I'm using SQL Server 2000 SP3 to store data for real time transactionprocessing.I have set up replication to another server using a push subscription togive me immediate backup.I need to alter the data type of one of the columns and am using thefollowing basic sql:alter table Voucheralter column SerialNumber varchar(20) NOT NULLHowever I keep getting this error message:Server: Msg 4929, Level 16, State 1, Line 1Cannot alter the table 'Terminals' because it is being published forreplication.Is there anything I can do to allow this update taking place, short ofdeleting the subscription and recreating it. (I want to try and avoidthis as the same update needs to be applied to about 10 databases thatare also replicated in the same way).All help is appreciated.Brian.*** Sent via Developersdex http://www.developersdex.com ***

View 4 Replies View Related

Published Paper For Db Performance Strategies?

Jul 20, 2005

I am looking for some published paper regarding database performancetunning performance strategies. This is for academic purpose so itneeds not to be any commerical database specific. It will be evenbetter if the paper has some kind of methods to quantify/measureperformance. Has anyone come across with any interesting paper aboutthis?Thanks,ewong

View 2 Replies View Related

Detect Changes On Indexes In A Published Table

Jul 27, 2006

Hi,

Regarding to my previous post at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=553652&SiteID=1, just wondering if there's a way to detect any changes which is made on the existing indexes in a published table so that the device can determine whether reinitialization of subscrption is needed before every synchronization.

Cheers,
Justin

View 3 Replies View Related

Report Gives Parameter Error When Published

Nov 14, 2007

I have been working on parameterised reports for quite a while and have a problem with a report that I cannot fathom despite days spent fiddling. I am hoping someone will be able to spot a silly mistake...

Basically, I am developing my report in VS2005 and it works perfectly. When I publish it to the reporting server I get an error: The 'pSite' parameter is missing a value.

I cannot understand why the report should fail when published.


Before anyone says it, yes I have deleted the published report and re-deployed so there should be no chance of any 'old' deployments messing things up!

Any obvious suggestions before I start posting code?!


Thanks all



Will

View 3 Replies View Related

Can I Use A Published Report As A Datasource For Other Reports?

Feb 6, 2007

Hi,

I have a data table called STOCKPE which holds stock valuation information at the close of business each day. I wish to use reporting services to extract the data in this table on a daily basis and keep a daily history on the report server. I know I can do this - this isn't my problem.

When I have the history of this table on the report server, can the data that the reports on the report server hold be used as a datasource for another report?

I'm no expert in reporting services, so if this is possible, or if there's a better way of doing it, please use small words and short sentences. No offence intended to all the very well educated SQLRS wizards out there, it's just that I'm not one of them and your answer will be lost on me if you use a lot of abreviations and acronyms.

Thanks,

Chris

View 3 Replies View Related

Calling DTS Via ASP.NET Works Locally But Not When Published To Intranet

Jan 19, 2007

I have a DTS package that I am calling in my code-behind (vb) of one of my asp.net pages on my intranet. The package takes a FoxPro table that is on our network and inserts it into a SQL Server table in one of our databases. The package gets called and executed properly when I am working on it in development on my local workstation, but when I publish it to our intranet, which is in the same domain and behind the same firewall, the package does not execute. No error shows up on the published page, but also nothing gets executed. Has anyone encountered this? Here is my code, which is pretty straightforward:
oPkg = Server.CreateObject("DTS.Package")oPkg.LoadFromSQLServer("[servername]", "sa", "[password]", DTSSQLStgFlag_Default, "", "", "", "Invoice Import")oPkg.Execute()
Any help would be appreciated. Thanks.

View 3 Replies View Related

How To Add Tabls To Published Article Without Recreating Snapshot?

Jan 26, 2007

Hi experts:

We have 4 SQL SERVER 2000 servers linked via replication, and due to business changes we have to add one table to the published databases. And the existed database has more than 20g, recreating the snapshot and re-init replication is not allowed as the business cannot be stopped more than 1 hour. So my question is how to add tables to the published article without recreating the snapshot?

By that is not possilbe, can we publish one new article on the same database?



Thanks in advance!

Ron

View 1 Replies View Related

Error When Changing Published Article At The Subscriber

Mar 9, 2006

Hi


Using merge replication - the stored procs are published articles.


When trying to change the article at the subscriber (sql express) I get the following errors:

Msg 21531, Level 16, State 1, Procedure sp_MSmerge_alterschemaonly, Line 45
The DDL statement cannot be performed at the Subscriber or Republisher.

Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 181
The DDL operation failed inside merge DDL replication manipulation.

Msg 3609, Level 16, State 2, Procedure usp_Anniversary_upd, Line 21
The transaction ended in the trigger. The batch has been aborted.



Does this mean it can only be changed at the publisher ?

Bruce

View 5 Replies View Related

SQL 2005 How To Change @conflict_retention For Articles Already Published

Dec 19, 2005

Hello,

    I have some articles already published and would like to change some of the articles default @conflict_retention of 14 days to 45 days. How can I accomplish this via t-sql? Thanks.

 

John

 

 

View 1 Replies View Related

Add A Column To Published Table Without Replicating To Subscriber

May 25, 2006

I would like to add a column to a published table but not have that column replicated to subscribers. I can accomplish this via the UI by adding the column and then unchecking it. This adds the column to the publisher table but does not replicate it to the subscriber.

I am looking for a programmatic method to add a column to the base table and unmark it for replication.

Thanks for your assistance.

View 4 Replies View Related

One Application With 2 DataBase

Aug 6, 2007

Hai All ,
        Iam having the one Application in DotNet2005.But iam using the two database(SqlServer2005).If user's login the application it will check credentials in first database, if he is not having the login credentials it will cheek the second Database. How can I handle in the configuration file?. How can I change the connection string depending upon the Database in my application for database operation (like insert and update).Any one kindly provide the solution.Thanks and regards,sureshK 
 

View 7 Replies View Related

Why Report Can Be Previewed But When Published To Localhost, Failed To Open

Jun 14, 2006

Hello, everyone

I generate a report (.RDL) using sql server 2005 reporting service. The tools is visual studio2005. I am runing it on windows server 2000 sp4.

Then I create a website and addin a page Default.aspx using reportviewer control to display the report (.RDL) I published in

Http://localhost/reportserver$Sqlexpress/Report Project1/Report1

The report simply just report a tables content and i can preview it by Ctrl+F5 without problem.

However, after I publish the website to localhost,which is Http://localhost/ViewReport/. I failed to open the report in http://localhost/viewreport/default.aspx The page is opened but there is a error message at the reportviewer portion.

" ASPNET user don't have permission to view the report.." something like that.

Anyone know what causes the problem?

I am thinking is it because I am using build in account "Local system" to run the Sql express 2005 Databaes and reporting service? But I have no choice, when I install the SQl express 2005, the only build in account I have is "Local System", but "Local Service " and" Network Service" is missing from my system. It is weird. Is it because of windows server 2000?

Any reply will be appreciated.

View 5 Replies View Related

Reporting Services :: SSRS Error When Published With Apache

Jul 7, 2015

We are using SQL Server Reporting Services 2012 with SharePoint 2013, we had publish the App with Apache Reverse Proxy.

The detail of the server is:
/serveis/app/apache/bin/apachectl -version
Server version: Apache/2.2.29 (Unix)
Server built:   Apr 14 2015 10:36:40

We can open the report with no problem, but when we click in Actions menu we have a time out.I need to know if it is possible to know which url is trying to open, or if it is any kind of debug mode.

View 4 Replies View Related

Microsoft's Connectivity White Paper Is Officially Published

Feb 14, 2007

Hello All!

Many of you have seen the draft version, but we finally have it out the door. You can download the new version directly from Microsoft's official site.

The momentum in our connecitivty wiki is growing! so check back and see if you can get useful information on 64bit, Office 2007 connecitivity, and samples.

Some of the recent activity in our connectivity portal:

***************

The new connectivity white paper is now officially available, click here (http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/ConnectivitySSIS.doc) to download.

***************

There's a new article from Deniz Erkan on Office 2007 Connectivity (Data Sources/Microsoft Office (2007)).

***************

Bob Beauschemin provided us a sample package to connect to Excel 2007.

***************

Microsoft's Partner ETI has a new separate page for connectivity offerings for SSIS (Data Sources/ETI High Performance Data Integration).

***************

Microsoft's Partner Persistent (Data Sources/Persistent Systems Products for SSIS) has put together a list of options for SSIS connectivity.

********************************************************************

View 4 Replies View Related

How To Avoid Non-published Columns Deletion On Subscriptions' Reset

Apr 26, 2007

Hi all!
I have been doing some testing with transactional replication. I have a table (TEST) with the following columns:

[id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[name] [varchar](50) COLLATE SQL_Latin1_General_CP850_CI_AS NULL,
[stock] [int] NOT NULL CONSTRAINT [DF_Prueba1_stock] DEFAULT ((0)),

I want the table rows to have an independent stock value for each database. So,
I made a transactional publication with updatable subscriptions, to replicate all the table columns, except the stock column.

The problem is when I reset subscriptions: the table is deleted an created again on the subscriber, so all the data stored at the stock column is lost. I tried to solve this changing the "Action if name is in use" option at the publication. I choose to keep the current object without changes, but I began having problems with the generation of the identity values at the subscriber.

Any suggestions will be welcomed

Thanks in advance ;-)

View 8 Replies View Related

History Of Report Definition File For Published Reports...

Jun 26, 2007

I would like to know if there is a way to maintain the history of changes to the reports that have been published to the report server?

I know that the report definitions get saved onto ReportServer database. But let's say a user makes a change to the published report and then saves it back to the server. And that the latest change was incorrect and I have to revert back to the previous version of the published report. Is there a way to do that? Does the report server maintain a history of previous versions.

There is a history for each report and I think that corresponds to the history of report executions (output data). But I am talking about the history of actual report definition.

Thanks for you help.

View 2 Replies View Related







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