I developped a project using Visual Studio 2005 Standard Edition on a XP pro x64 Machine using a developpemet data area on a SQL 2005 Express Edition.
Everything is ok, even the user and profile management. But when I try to publish my application on IIS (we're talking about a little Intranet), I get my problems. I think is important to say that the server is a Windows Server 2003 and data (database reproduced as a backup of the developpement one) are under an SQL 2005 Standard. The strange thing is that by publishing the "site" VS create a DB under SQL Std named with the path of local ASPNETDB.MDF.
I can reach everything, all data are ok, but when I pass the login page going to main menu on my web-application, I get this 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)
I think the problem is SQL STD and the fact that it's not "able" to manage MDF files.
I even tried to re-map the SQL DB (named simply as ASPNETDB on the SQL std) by adjusting the web.config file on connection type and user and password to reach the DB ASPNETDB but it does't work anyway.
web site made in web dev db all ok locally got server at local ip....... need to upload script files to server... got microsoft publishing wizard all working and database all scripted out. server consul looks like horrible unix outfit.....virtuozzo question is now what? ip says use enterprise manager to publish to server......is that the old version of management studio express, which i have
Hi Guys, I have been trying to use SQL Server 7.0's Web page Publishing tools with Microsoft Frontpage without sucess. I can created the web pages using SQL that it works fine. I have the page set to change automatically when the data is changed and this works while the page is accessed from the SQL Server, however when I upload the page to a frontpage Web, the automatic update does not work. Any ideas what I'm doing wrong?
I am experimenting with the Web Publishing feature in MSSQL 70. Does anyone have any pros and cons when utilizing this feature within MSSQL 70?
I also would like to ask if anyone knows of a different way to access the Web Page designed other than placing it in an accessible file either in a repository or a central site and have people click on the *.htm document thus pulling up the related page on the W3.
Has anyone been able to go from the MSSQL 70 directly to a browser instead of opening the created *.htm file?
We are experiencing intermitant problems on out SQL 7 system. Its running FTP publishing, MS SMTP service and the www publishing service. We reset the services using net stop <service> each morning. When I use the command 'net stop www publishing service' I get the message - The service could not be controlled in its present state. This would indicate that the service has hung. The problems seem to happen over night and is cured by a reboot.
When managing publication for a particular database, not all the tables are listed as articles to add to the publication. Is this a permissions problem? Any way I can check out why they aren't available or, better yet, make them available for the publication?
Hi! How is it possible to set up a repl. scenario, where a subscriber of a DB is also the publisher of this DB for other subscribers. i mean 3 level repliction. MAINPUB SUB1 SUB2 SUB3 notebookSUB1...................notebooksubN
SUB1..3 are subscribing to MAINSUB and publishing to a number of notebooks!
I am using ASP.NET 2.0 C#, SQL Server 2000Connection string is: "Data Source=USMAN;Initial Catalog=CMS;Integrated Security=True" And by searching forums and goodle, I have also set sql server 2000's secutiry as mixed modeInfact When I compile and run my projcet from visual studio it is fine, every thing works ok Then I publish my site to a folder on desktop, when publishing completed I right clicked the folder and in web sharing option I added alias = CMS Now when I open: http://localhost/CMS/Home.aspx, then it works fine infact all the pages that dont have SQL Server 2000 connectivity work fine, but as soon as I open some page that has connectivity with the database, it gives me error like: Login failed for user'USMAN/ASPNET' I wonder why this error only comes after publishing, there is nothing probemaltic when running it from Visual Studio, plz tell me what to do
HI, I am working on a project in which a user can upload his database to the server...then he is able to view all the schema or execute any kind of query. Then he goes to some other machine and login and wants to download the database. For example Alex have uploaded the database consisting of 1000 records to mysite. Then He goes to texas to find some oil wells. He is on another machine ... I download the database .... inseert new records and upload it back. Its an example basically I want to know how to include the users' uploaded into my sqlserver and when required publish with data on his machine... Thanks.
I've been working with the Database Publishing Wizard and have found what I initially thought was a bug but have decided is a rather nasty "feature". Or am I missing something? I have membership implemented in a live database. I took a backup and loaded it into a local database. I created a new table locally that is foreign-keyed off aspnet_roles, and added some data. Using the Publishing Wizard for a partial deployment, I followed the steps which seem perfectly clear to script out ONLY the new table and its data. The screens provide a nice GUI for selecting specific database objects, and I carefully chose the one new table. From good habits I looked at the script before deploying it. It drops and recreates aspnet_roles and aspnet_applications as well (and inserts the data from the development tables). Presumably this is because of the foreign key relationships. But there's no need to do so. What if I or another developer had added in some roles to the live table in the meantime? This script would blow them away. Am I missing an option with the Wizard that would script out only what is specified? I've tidied up the script (i.e. removed the undesirable sections) - but this seems to be a naughty wizard. Any thoughts?
We are trying to script out database schema and data with the Database Publishing Wizard and are having problems with output script trying to create views and stored procedures before the tables they depend on. I've seen discussion of this on their codeplex site and back in April 2007 they said that the CTP they just released fixed the problem - but we are still seeing it. Does anyone know a solution for this (beyond the obvious copy and pasting into the right order)? What we are trying to do is move the SQL and some basic reference data into source control and a CI process.
I received this publishing error a while back and can't think of a reason I would be receiving this error.
SQL error occurred. See entry specific information. Error : 21010, 01000, [Microsoft][ODBC SQL Server Driver][SQL Server]Removed 0 replicated transactions consisting of 0 statements in 6 seconds (0 rows/sec).
The error came just before another error:
SQL error occurred. See entry specific information. Information : 1205, 40001, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I'm wondering what would cause these errors, if someone could point me in the right direction that would be great.
I have created reports in SQL Server reporting services(SSRS)and when i publish the report in the Localhost server it can be viewed in browser only in the INTRANET network but my intention is to generate the INTERNET URL of the report such that report published can be viewed in INTERNET outside this network..
I have developed a database application using c# and SQL Express 2005.
I have coded a connection string that works fine on the development machine but upon publishing to another machine I am getting the following error message:
Cannot open database "name of database" requested by the login. The login failed. Login Failed for user "machine nameuser name".
The remote machine has SQL server express installed.
Now on the development machine the machine name and user names are different to that on the remote machine. I am using Windows Auth. The application successfully runs on the remote machine. It even updates the same database (as mentioned in the issue above) on a different form which all connection strings etc were created automatically by c#. I'm pretty new to all this and don't know where to go from here. Any help would be greatly appritiated.
Anyone know how I can direct different reports in the same project to different folder on the SSRS site? I can get everyone to publish to one folder, but want to know if its possible on a report/report basis to different folders
I have developed a database application using c# and SQL Express 2005.
I have coded a connection string that works fine on the development machine but upon publishing to another machine I am getting the following error message:
Cannot open database "name of database" requested by the login. The login failed. Login Failed for user "machine nameuser name".
The remote machine has SQL server express installed.
Now on the development machine the machine name and user names are different to that on the remote machine. I am using Windows Auth. The application successfully runs on the remote machine. It even updates the same database (as mentioned in the issue above) on a different form which all connection strings etc were created automatically by c#. I'm pretty new to all this and don't know where to go from here. Any help would be greatly appritiated.
When I try to 'Install Publishing' from the 'Replication Configuration' drop down on the 'Server' Menu within Server Manager I receive the following error:
"Replication cannot be installed as @@SERVERNAME is NULL"
I am trying to disable publishing on a server. When I attempt to do so I get the following error:
"Error 8157: All the queries in a query expression containing a UNION operator must have the same number of expressions in their select lists. Could no use view of function 'sysextendedarticlesview' because of binding errors."
There is more error message text but it's a repeat of the UNION and sysextendedarticlesview problem.
Now here is something I have been asking the SQL Server Team for a long long while : http://www.microsoft.com/downloads/details.aspx?familyid=16D8C1E9-A6A3-43A2-9BA7-916C6EB5023B&mg_id=10046&displaylang=en . I hope this will be of use to many of us
I am publishing a SQL view in excell using the external data/new database query option and accessing SQL server via ODBC datasource defined.
The query I use aggregates data between 2 diferent dates. I am able to pass the initial date and the end date to SQL, but the results are not aggregated becase I am forced to put in the view the GroupBy clause for the field DATE. Is there any way of passing parameters to SQL (via Excell) and retrienve the aggregated data based on this parameters?
Hi, I was wondering if anyone had an idea if it's possible to run a stored procedure that would basically output a .sql file used to recreate the database elsewhere. kinda like the data publishing wizard does.
I have a dropdown which shows all the available reports on reporting server. What I want to do is when a user select a report from dropdown and click on RUN REPORT button. That particular report will run. I am using VB.NET 2.0 version. One way which i am thinking is to use ReportViewer Control. Is there any other way to publish the reports in window forms or ReportViewer will take care. Kindly guide.
Have host of web applications deployed under websites ( /app1,/app2,/app3) We have created a virtual directory under website ( /web) All the virtualdirectories created under root is again creaed under web virtual directory ( /web/app1,/web/app2,/web/app3) Reportserver is configured to work (website/reports) And manually reports virtual directory created (website/web/reports)
work€¦I am able to view reports from internet using http://domainname/web/reports
but when I lauch reports from http://domainname/web/app1 reports are not getting launched .can comeone suggest where I went wrong in configuring i have oly port80,443 open between my ISA server and webserver.
I have created a web site containing a login control. It works great on my local machine, but when I copy it to the server, I get the following error when I try to login to the website: Server Error in '/mrallensclass' Application.
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)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
The SQL Server group at Microsoft has just launched the SQL Server Hosting Toolkit with the release of the Database Publishing Wizard Community Technology Preview 1.The objective of the SQL Server Hosting Toolkit is to enable a great experience around hosted SQL Server. The Database Publishing Wizard works toward this mission by making it easy to upload a database from a development box up to a shared hoster. In its first incarnation, the Database Publishing Wizard is a command line tool that generates a T-SQL script designed to be executed in the script execution windows provided by most hosters in their database management consoles. In the coming months we'll be adding a GUI and building seamless integration between the tool and an upload service we'll provide to hosters for deployment.Details on the Database Publishing Wizard as well as the download can be found at http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard.We plan to be releasing advances in the Toolkit frequently so check out this first CTP and give us your feedback!Thanks,Dan WinnSenior Program Manager, Microsoft SQL Server
Thanks for taking your time to read this.(sorry if someone posted this earlier but no solutions helped)
After i published my website, i am unable to login anymore. It has this error of "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." Note ** im using vb
i want to use Replication in sql server 2000 at specified condtion ,mean if any condition is satisfied then the data is publish to subscriber database?
