Open dineshkummarc opened 11 years ago
added a label named in-progress as the issue is in update process
-> Got This solution from support.godaddy.com team member and user conversation.
Cannot locate Publishing Service URL for SQL Server 2005 DB I am trying to publish a local MSSQL 2005 database to an empty database on my hosting that I created, which is also MSSQL 2005. The help articles on this site suggest using the Database Publishing Wizard (with the caveat that it does not work with MSSQL 2008). I have downloaded this wizard, and attempted to follow the instructions linked to on various help articles here. There is missing information, however. The wizard requires a connection address – the ‘Web Service address’. In various help responses on this site, there is reference to this Publishing Service URL. Comments suggest that it should be visible on the Database Information page in the control panel (at least in some previous incarnation of this website). I visit my database control panel. I click ‘Actions->Details’, and a popup shows various details. Nothing labeled ‘Publshing Service URL’. I then click on ‘CodeSample’. Another popup, with some helpful connection strings, displays. The following: “” Here’s an example of how to connect to your database. Learn more » The following is a list of database connection strings to use with various SQL Server data providers. Cut and paste the connection string to use within your application. For connection strings that require a password, update the password field to the designated password for the database. ODBC: Driver={SQL Server}; Server=_.db..hostedresource.com; Database=**; Uid=_; Pwd=’your password’; OLE DB, OleDbConnection (.NET): Provider=sqloledb; Data Source=.db.**.hostedresource.com; Initial Catalog=_; User ID=; Password=’your password’; SqlConnection (.NET): Data Source=**.db._.hostedresource.com; Initial Catalog=; User ID=**; Password=’your password’; “” Nowhere in here is a Publishing Service URL. Where is this located?
@charlesbob The Publishing Service URL should be called “Admin URL:” in your Hosting ‘Actions’ pop-up. If you do not see this ‘Actions->Details’ pop-up, please contact our 24/7 Support Team so they may take a look at your database specifically. Thanks! -Donald
Thank you for the clarification. Now that I’m using the proper web service address, I can say that I’m receiving an error with it. I get an error when I click ‘Test’ in the Database Publishing Wizard – I have entered the Admin URL, as well as valid FTP username and password. This happens regardless of whether I have added ‘available databases’ to the provided list. Here is my error:
The request failed with HTTP status 405: Method Not Allowed. (System.Web.Services) —————————— Program Location: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.Tools.HostingServices.PublishService.GetServiceOptions() at Microsoft.SqlServer.Management.SqlManagerUI.ProviderListDialog.TestProvider(ProviderEntity provider) “” Do you know what this could be?
I do also receive this error message. Any success?
@charlesbob When connecting to your database externally, you’ll want to ensure you are using the database login information and not your FTP login information. If your database login information is set differently than your FTP login information, the username and password will need to be updated in the Database Publishing Wizard. -Adam
I am also having the same issue, I get an error when I click ‘Test’ in the Database Publishing Wizard – I have entered the Admin URL, as well as valid FTP username and password. This happens regardless of whether I have added ‘available databases’ to the provided list. Here is my error:
The request failed with HTTP status 405: Method Not Allowed. (System.Web.Services) —————————— @jaypal_mandloi Are you sure you’re working with a MSSQL 2005 database? If you setup the database as a MSSQL 2008 database, you will not be able to connect using the Database Publishing Wizard. -Adam
came up with a solution
Making Database Connections
Connect to Oracle and third-party databases from Oracle SQL Developer.
Oracle SQL Developer enables developers and DBAs to browse, create, and update data in a database. Before you can perform those actions, however, you must create at least one database connection an Oracle SQL Developer object containing the information needed to connect to a specific database as a specific user.
This column explains how to make connections from Oracle SQL Developer to an Oracle Database and third-party databases. It also discusses authorization options for Oracle Database connections and explains the role of JDBC drivers in the connection process.
All the examples in this column require Oracle SQL Developer to be running on your local machine. For some examples, you need access to a running local or remote Oracle Database instance with the sample HR schema (available in the default database installation). Other examples require access to an Oracle Internet Directory server or a third-party database. Basic Connections
You can connect to a local or remote Oracle Database instance by using the Basic connection type. Basic connections do not require any other Oracle software to be installed on your machineyou don't need an Oracle home.
Right-click the Connections node in Oracle SQL Developer's Connections Navigator, and click New Connection to open the New / Select Database Connection dialog box. All of this column's connection examples start from this dialog box.
To create a basic connection for the HR schema, follow these steps:
Provide information for the following settings:
Role: This is the set of privileges to be associated with the connection. Accept default for this connection. OS Authentication: Leave this unchecked for this connection. Proxy Connection: Leave this unchecked for this connection. Hostname: This is the host system for the Oracle Database instance. Enter an IP address, a machine name, or localhost (when connecting to a database on the same machine as Oracle SQL Developer). The default is localhost . Port: This is the listener port for the database. The default port for Oracle Database is 1521. SID: This is the system identifier, such as orcl (the default for Oracle Database 10g and Oracle Database 11g) or xe (the default for Oracle Database 10g Express Edition). Service name: This is the network service name of the database. Select either SID or Service name.
Now HR_ORCL appears in Connections Navigator, and you can expand it to browse the database. TNS Connections
The TNS connection type is an appropriate option in any of the following circumstances:
You have an Oracle client installed on your machine. You have access to many Oracle Database instances. You do not know the machine details of the system hosting the Oracle Database instance you want to connect to. A TNS connection uses an alias entry from a tnsnames.ora file. Oracle SQL Developer uses only one tnsnames.ora file. You may have more than one on your local machine or want to use the tnsnames.ora file on a remote machine, so note that Oracle SQL Developer looks sequentially for the tnsnames.ora file in the following locations:
On Windows systems, if a tnsnames .ora file exists but Oracle SQL Developer isn't using it, create a TNS_ADMIN environment variable via Control Panel -> System -> Advanced -> Environment Variables , specifying the file's location as the variable's value.
Follow these steps to create a TNS connection in Oracle SQL Developer:
Oracle Internet Directory is a directory service that enables you to store and manage network service names centrally. With it, user identity information can be stored in a directory instead of in multiple databases. Oracle Internet Directory is an implementation of the LDAP directory service and a component of Oracle Identity Management. For information on how to install, set up, and configure Oracle Internet Directory, see the Oracle Internet Directory Administrator's Guide.
To look up database services in Oracle Internet Directory and create an LDAP connection in Oracle SQL Developer, follow these steps:
Alternatives to database authentication and LDAP authentication include operating system (OS) and proxy authentication. You can create connections in Oracle SQL Developer for users who authenticate with these mechanisms. OS authentication. With OS authentication, Oracle Database uses a database user's OS login credentials to authenticate that user. The user doesn't provide a username or password to access the database, and Oracle Database doesn't store and manage the account password. Local OS authentication can be used when the client and the database server are on the same machine. Remote OS authentication is possible but is not considered secure.
To configure local OS authentication for a new user, first find the value of the OS_AUTHENT_PREFIX database initialization parameter in your system's init.ora file. When you create this new user in the database, you must add this parameter value as a prefix to the OS username. The default value is OPS$, for backward compatibility with earlier database releases. (If the value is "", the OS username and the database username are the same, so you don't need to add a prefix to create the Oracle usernames.)
Establish a basic connection with the HR schema as the SYSTEM user. Execute the following from the SQL worksheet, using your database's OS_AUTHENT_PREFIX prefix and substituting your own OS username for "sue":
CREATE USER ops$sue IDENTIFIED EXTERNALLY; GRANT Connect, resource to sue;
Now create a basic connection for this user from the New / Select Database Connection dialog box. Enter a connection name; select Basic for Connection Type ; fill in the Hostname and Port fields; select OS Authentication ; and provide a SID or Service name . Click Test and Connect as before.
Proxy authentication. Proxy authentication means that one JDBC connection acts as a proxy for other JDBC connections. Before you can create a connection that uses proxy authentication, you need a proxy user. In the following example, you create a new user named HR_PROXY_USER and connect that user through the existing HR user.
To create the new proxy user (HR_PROXY_USER) and grant the correct proxy authentication privileges, execute the following in the SQL worksheet:
CREATE USER HR_proxy_user IDENTIFIED BY < password>; ALTER USER HR_proxy_user GRANT CONNECT THROUGH HR AUTHENTICATED USING PASSWORD;
You also need to grant any other privileges required by the new user, such as CREATE SESSION.
Once your proxy user exists, you can create a new proxy connection for HR in Oracle SQL Developer. Select Proxy Connection in the New / Select Database Connection dialog box, and complete the details in the Oracle Proxy Connection dialog box, as shown in Figure 3. Connecting to Third-Party Databases
Oracle SQL Developer supports browsing and reviewing data and objects in Microsoft Access, MySQL, Microsoft SQL Server, and Sybase. It also offers a SQL worksheet for ANSI SQL commands to update or create objects for these databases. Users who want to migrate from third-party databases to Oracle Database can use the Oracle SQL Developer Migration Workbench. For any of these situations, you need to create a connection to your third-party database.
Installing third-party drivers. The correct third-party driver must be installed before you can create the connection. You can install third-party drivers either manually or by using Check for Updates ( Help->Check for Updates ). For manual installation, you can download supported drivers from the following locations:
MySQL JDBC driver, version 5.08: dev.mysql.com/downloads/connector/j/5.0.html.
jTDS driver, version 1.2 (required by Microsoft SQL Server and Sybase): source forge.net/project/showfiles.php?group_id=33291. (See jtds.sourceforge.net for information about this driver.)
Microsoft Access does not require an additional driver, because it uses a JDBC/ODBC bridge.
After downloading the driver you need, expand the driver binary Java Archive (JAR) file, which is typically inside the downloaded archive file:
The mysql-connector-java-5.0.8.tar.gz (or .zip) download for MySQL includes mysql-connector-java-5.0.8-bin.jar.
The jtds-1.2-dist.zip file for Microsoft SQL Server and Sybase includes jtds-1.2.jar.
Select Tools -> Preferences -> Database -> Third Party JDBC Drivers . Click Add Entry , and add your specific JAR file. Now you can create a connection for your third-party database.
Creating a Microsoft Access connection. To create a connection for Microsoft Access, follow these steps in the New / Select Database Connection dialog box:
You can now expand and browse the new Microsoft Access connection in the Connections Navigator.
Creating a Microsoft SQL Server, Sybase, or MySQL connection. To create a connection to a Microsoft SQL Server, Sybase, or MySQL database in the New / Select Database Connection dialog box, follow these steps:
Oracle SQL Developer provides an array of alternatives for connecting to Oracle and third-party databases. Support for both Oracle JDBC Type IV (thin) and Type II (thick) drivers lets you access Oracle Databases via basic, TNS, or LDAP connection types. You can make connections for Oracle Database users who authenticate via database, OS, or proxy authentication. Connecting to a third-party database from Oracle SQL Developer lets you work in that database and gives you a starting point for migrating to Oracle Database.
Got these errors while updating database using Oracle SQL developer
At last used the download UrL for Query Analyser : http://www.devart.com/dbforge/sql/querybuilder/
done with errors on the system
Application started at 26-08-2013 18:39:29 Connection 'dashboardx' was added. Connection 'dashboardx' was connected. Start describe databases Databases described Start describe declarations in database "dashboardx" Declarations described in database "dashboardx". Describing time: 00:00:06.1950000
------ Execution started: script.sql ------
Changed database context to 'dashboardx'. Error (9272,2): Could not create constraint. See previous errors.
------------ Done: script.sql -------------
Application started at 27-08-2013 14:21:10 Connection 'DashboardX2' was added. Connection 'DashboardX2' was connected. Start describe databases Databases described Start describe declarations in database "DashboardX2" Declarations described in database "DashboardX2". Describing time: 00:00:15.7060000
------ Execution started: 04002013-DATABASE.sql ------
Execute succeeded [0.409s]
------------ Done: 04002013-DATABASE.sql -------------
------ Execution started: 01022012-ADDRESS.sql ------
Execute succeeded [0.437s]
------------ Done: 01022012-ADDRESS.sql -------------
------ Execution started: 01022012-RECIPE.sql ------
Execute succeeded [0.598s]
------------ Done: 01022012-RECIPE.sql -------------
------ Execution started: 01022012-WEBSHOP.sql ------
Execute succeeded [0.353s]
------------ Done: 01022012-WEBSHOP.sql -------------
------ Execution started: 01022012-ASPNETDB.sql ------
Execute succeeded [0.343s] Error (1460,1): Cannot find the user 'ERLS-BF7CF18DF9\ASPNET', because it does not exist or you do not have permission. Error (1459,1): CREATE SCHEMA failed due to previous errors. Execute failed [0.774s] Error (1464,1): Cannot find the user 'ERLS-BF7CF18DF9\SQLServer2005MSFTEUser$ERLS-BF7CF18DF9$MSSQLSERVER', because it does not exist or you do not have permission. Error (1463,1): CREATE SCHEMA failed due to previous errors. Execute failed [0.333s] Execute succeeded [0.477s]
------------ Done: 01022012-ASPNETDB.sql -------------
database is deployed on the server with the database name as 'dashboardx2'
deploy database on sql server 2008 for 20891198210