I designed the AlwaysOn wrong, but every time we fail over from primary server to another server, my applications cannot connect because the sql logins cannot connect to their default databases. Once I run the command to link the login with the user in the default database then the users are able to connect. Did I do something wrong when designing AlwaysOn?
View 9 RepliesI create default instance on SQL Server 2012 Standard.
When I set it up, I changed instance id from 'mssqlserver', which is a default value, to 'new_instance_id'.
For some reason I want to connect to the instance with computername new_instance_id
Can I do it?
Here is the big problem:
I am using ASP.NET 2.0 login control. this control connect to ASPNET.MDF database.
I built another application using windows service, and this application also connects to ASPNET.MDF database.
problem is that the first application that connects to the database, locks the database, and so the other application cannot use the database untill the other application is closed.
I am going on circles about this, and just don't know what to do.
Please please please. love me do.
I am working on a hospital application using java programming language, i need to know how to connect two applications to one table over a network where the data read by application one can not be read by application 2 and vise versa...
View 3 Replies View RelatedCan applications connect to SSAS Tabular mode cubes through ODBC drivers? I have been asked the question specifically regarding SAS, and I can see (for example) SAS Enterprise Guide has the ability to connect to sources via ODBC, so I now need to find out if there are such things as ODBC divers for SSAS (specifically Tabular).
View 3 Replies View Related
I connected successfully in SQL Server Management studio using the 'sa' login and changed the authentication mode to Windows NT because I could not connect using my windows login but now I can't get any connection at all because 'sa' is no longer trusted.
I changed the loginmode registry setting to 2 and rebooted my PC but this has made no difference.
Can anyone help me get the 'sa' login back?
hello,
i want to make a relation betwen one of my tables and the user tables (to take it's unique ID), if there isn't any methode to do that without using the two databases(ASPNETDB - automaticly created when a user registers, and MyData), how can i connect to both databases? here is my connection string, but what should i do?<connectionStrings>
<add name="SiteConnection" connectionString="Server=(local)SqlExpress; Integrated Security = True; Database = MyData" providerName="System.Data.SqlClient" />
<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|MyData.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings> thank you
When I try to connect to a default Express instance in Management Studio at the machine (Windows XP SP2) where the instance is installed, 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) (Microsoft SQL Server)
What does provider: SQL Network Interfaces mean? Does it mean the Shared Memory, Named Pipes and TCP/IP?
Additional information:
1. The following Network Protocols are enabled: Shared Memory, Named Pipes, TCP/IP thru Configuration Manager
2. SQL Server Express default instance is running using NT
AUTHORITYNetworkService.
3. SQL Server Browser service is not running. I believe this is not needed unless I want to connect to the instance from another machine.
4. Has tried to disable Windows Firewall but I believe it should not be matter in this particular case since this is within the same machine.
5. Can connect to the instance in ODBC Administrator using System DSN thru Named Pipes or TCP/IP.
Can such error caused by not having sufficient memory so the system is running kind of slow?
Hi, If you have 2 databases with the exact same table columns, and in the first database in a table column the indentidy seed starts at 1 and finishes at 32,000 can you attatch a second database so that the indentity starts at 32,001and carries on. What happens if you create a site and run out of disk space and need to attach another database which is located on another server??? I am really confused about this.Hope someone can give some links to some articles about this as I can't find any information about it.How can this be done? Thanks
View 1 Replies View RelatedHi
I have my database on four different database servers. I have a web appliction using asp.net 2.0. i want to add data to all four database servers. How can i do that with asp.net 2.0
Thanks in advance
Take care
Bye
Hello!
I have a problem connecting to two mssql databases to select data in one php script.
- I made two different include file to connect to the two db's
- in the php script I include both files
- my first select statement look as follows:
$msquery1 = "SELECT Dateiname FROM database1.dbo.table";
$msquery1 .= "WHERE AuftragNr = '$jobNr'";
$msresult1 = mssql_db_query($msquery1,$link1);
while ($mszeile1=mssql_fetch_array($msresult1))
{
...
echo "<td>$mszeile1[Dateiname]</td>";
...
}
mssql_close ($link1);
- the second select statement in the same file:
$msquery = "SELECT AdrName FROM database2.dbo.table";
$msquery .= "WHERE AuftragNr = '$AuftragNr'";
$msresult = mssql_db_query($msquery,$link);
while ($mszeile=mssql_fetch_array($msresult))
{
...
echo "<td>$mszeile[AdrName]</td>";
...
}
mssql_close ($link);
I am totally stuck - when I take one select out an run the other one separately I get the field contents I ask for.
Can anyone help - I searched this forum and many more but I cannot see where I go the wrong way.
Thanks very much in advance.
Marion
We are wanting to know how to connect 2 databases residing on 2SQL servers. The workstation has access to both databases. Join on Cols 1 and 2.
Server1, Database1, Table1, Column1 (Char)
Server2, Database2, Table2, Column2 (VarChar)
I have SQL 2012 database on availability group environment..Due to lack of space on SQL log partition. I have added to new hard drive configures on RAID1.Moved the ldf files from active partition to newly created partition.SMS change the path for log drive to new driveRestart SQL server services.I cannot connect to databases anymore and I have also lost all setting of Availability group..Error message
Event logs for Application
Log Name: Application
Source: MSSQLSERVER
Date: 16/07/2015 8:32:22 a.m.
Event ID: 5123
Task Category: Server
[code]...
I ran the command line tool C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regsql.exe. Then I ran the web config tool and tried to test the default provider and it keeps saying it couldn't connect to the database. The database exists in sqlExpress instance. Any ideas?
View 18 Replies View Related
There are two machines(A and B) in intranet . The network between the machines is well.
I can't use client in machine A to connect the sql server in Machine B until i set the "connection timeout" a bigger number such as 30 seconds. If i use the default "connection timeout" to connect , it will return a error message "
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
But The correspondence of executing sql command is very quick after the connection is established.
Why need i bigger "connection timeout"？ Is that a configuration problem?
Thanks
Hello , This is Vidya newly joined to this group.
I want some help ..... Its really urgent
In my project I want to connect to two databases on alocal server in SQL ? Is there any SQL query to connect two databases ?
Situation is=>
There are two Databases Db1, Db2. I want to take data from tables of Db1 to data of tables of Db2 and vice versa.I want simple SQL query without any scripting language or VB statements. Its very urgent Please help me in that.
I have sql task inside a foreach loop which needs connection to multiple databases on different servers. I can pass the server name and the database name as a parameter. Can someone please tell me what steps to follow? Thanks in advance
View 2 Replies View RelatedIn my IPAQ, I have been using SQL CE for databases with various sizes without any problem. I am creating the databases on my desktop using VS 2005. After I moved to VISTA, I have upgraded my VS 2005 to SP1 and SQL CE to 3.1. My databases which were created before worked without any problem. After I have created my databases via 3.1 on the desktop and moved them to Mobile, I had problems.
1. I specify Max database size parameter as the size of the database
2. If the size of the database is smaller than 16 then I specify 128
3. If the database is old version then program runs without any problems whatever the database size is
4. If the database is created with 3.1 and size is small (20MB, 60MB, etc) no problems arise
5. İf the databse is created with 3.1 and size is large (133MB, 174MB) then dbconnection.Open() command runs indefinitely and program hangs up .
My IPAQ runs "Microsoft Pocket PC Version 4.20.1081" and desktop runs VISTA Home Premium. I have installed VS 2005 SP1.
Thanks for any help
I have a server with 3 SQL Server named instances on it - servername, servername/TST and servername/GOLDSTD. I have several databases on the default instance (servername) but users cannot access the databases unless they are given system admin privileges to their login. This occurs using both SQL Server Logins and Windows authentication logins. If I move the database to a different named instance (servername/TST), the problem no longer exists and users can connect with dbo privileges. Any suggestions or is this typical for default instances? Thanks in advance for any help
View 8 Replies View RelatedI just installed SQL Server 2005 CTP (9.00.1116) on Windows Server 2003 with SP1. Then I unzipped DotNetNuke portal site and tried to connect to it with various errors, generally relating to invalid login.
View 3 Replies View RelatedDim strCON As String = _
"workstation id=DJI-MAIN;packet size=4096;user id=sa;integrated security=SSPI;data source=DJI-MAIN;persist security info=False;initial catalog=RacingSystem"
Dim cnn1 As New SqlConnection(strCON)
cnn1.Open()
This is the code I have been using to connect to my default instance for 18 months. A recent upgrade to Windows Live onecare now prevents me connecting to the server from the same machine. The following error message is generated:-
Unhandled Exception: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at TrainerReport001.Form1.Form1_Load(Object sender, EventArgs e) in F:#ProjectsStatsOwnerReport001Form1.vb:line 84
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)The program '[3336] TrainerReport001.exe' has exited with code 0 (0x0).
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at TrainerReport001.Form1.Main() in F:#ProjectsStatsOwnerReport001Form1.vb:line 2
If I turn off the onecare firewall I can connect as normal, but this is not a desired option. I have tried enabling port 1433 on the firewall, this does not work either. Any help greatly appreciated, onecare support seems reluctant to help.
TIA
Good morning all,
I need to create a new table on a SQL Server 2005 Database, but the data needed for the table is kept in different databases on different servers.
Half the data is on the SQL 2005 database, so that shouldn't be too much of a problem, but the other half is on a SQL Express database on a different server, is it possible to write a T-SQL query to retrieve this data on the other server?
Normally I use a create table + insert into kind of query to create custom tables but I don't know how to connect to the SQL Express server/database using T-SQL (if it's possible at all?) to do this.
Any tips, hints, ideas very welcome. Please use small words and short sentences.
Thanks,
Paul
I try to import my SSIS packages which are created using the Business Intelligent studio into SQL server 2005 but I cannot do that.
I am running SQL server 2005 enterprise edition.
Also when i tried to connect to Integration services using Object explorer, it only prompt me for server name. I cannot change the username and password which is disabled.
Then how am i supposed to connect to Integration services on a server in this case?
I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).
The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.
SQL Server Express 2005 is installed in mixed mode.
Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.
These are my values in my Java app web.xml -
<init-param>
<param-name>DBDriver</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>
<init-param>
<param-name>DBURL</param-name> <param-value>jdbc:sqlserver://localhostsqlexpress:1055;databaseName=CORNERS</param-value>
</init-param>
<init-param>
<param-name>DBUser</param-name>
<param-value>sa</param-value>
</init-param>
<init-param>
<param-name>DBPwd</param-name>
<param-value>myPasswd</param-value>
</init-param>.
And yes, the port is 1055 - I checked to find it.
I am using Microsoft SQL Server 2005 JDBC Driver 1.0 (sqljdbc_1.0.809.102).
Does anyone have any idea what is wrong so that the login fails in the Java application but works in the .Net application?
I am struggling to set a SQL Server Express for remote access...
Since it is the only instance on this server, I have set it up to use port 1433 by amending the IPALL entry of the Server Network Configuration, TCP/IP Properties.
I have also disabled "Shared Memory" and "Named Pipes" to leave only TCP/IP enabled as a server network config.
I have stopped the Browser Service because I think I don't need it if I use port 1433.
From the server itself, I can connect to my SQL Server through "localhostSQLEXPRESS" or "servernameSQLEXPRESS" but not from "10.xxx.xxx.xxxSQLEXPRESS" or "127.0.0.1SQLEXPRESS"
I suppose until I can access my server from itself using the IPAddress, there is no chance connecting remotely...
I use SQL Server 2012 Management Studio, SQL Server Data Tools and Visual Studio 2012 to deploy a data mining project.
I get the following error message: A connection can not be made. Make sure the server is running.
I am able to pick up the database using the details below:
Machine Name: NIRMALK01-PC
SQL Server: SQLEXPRESS
SQL EXPRESS: Running
SQL BROWSER: Running
SQL Agent: DISABLED
I can not find Analysis Services in services.msc
This is the error: Error 1
The project could not be deployed to the 'nirmalk01-pcsqlexpress' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.
I had two servers, in which SQL Servers are installed. I created a alias for server
Server 1 : test1.sqlcloud.com (Alias name with port no other than 1433)
Server 2 : test2.sqlcloud.com (Alias name with port no other than 1433)
I can connect to the servers using the port. for ex server1 to server2 and viceversa using "test2.sqlcloud.com,port". But I could not connect to the server by only specifying the alias name ("test2.sqlcloud.com"). When I am connecting I am getting the following error.
"TITLE: Connect to Server
------------------------------
Cannot connect to test2.sqlcloud.com.
------------------------------
ADDITIONAL INFORMATION:
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=21020; handshake=0; (Microsoft SQL Server, Error: -2)
We have a monitor tool to monitor our SQL servers.The vendor has a script to grant permission to application account to SQL server so that they can do the monitoring.
I don't want to grant system admin role, but the script they have is very specific, the minimum is:
must be a member of db_datareader role on the msdb database
must have view server state permissions
view any definition
connection permission to master database
execute permission on the xp_readerrorlog stored procedure
connect permission to the msdb database
must be member of db_Datareader role in the msdb datab ase
connect permission to all databases.
The script given by vendor is as follows in the attachment.I don't like the last execute statement for if a new database is created, we have to remember manually add the monitoring acccount to that database.
I know in SQL 2014 it has a new feature of connect to any database, but unfortunately we are using SQL 2012 and 2008.
script to connect to any database but no need to add that each time we creates a new database.
I have very unusual question. I have seen a query that looks something like this:
SELECT A, B, C FROM 'LDAP://abc.def.com'
What exactly does this mean? Could such a query be executed in the SQL Server Management Studio? Where would such a table/database be actually located?
Enabled DAC and when connecting, I get a "Failed to connect to server ADMIN:SERVERINSTANCE"; however query window shows I'm connected on ADMIN:SERVERINSTANCE and checking tcp_endpoints + dm_exec_sessions, I'm definitely on the DAC.
View 1 Replies View RelatedEvery time I start SSMS 2012 the "Connect to Server" box is partially obscured in that the top of it, the move bar can't be accessed. I've manually moved it using "alt+space" then "M" followed by the arrow keys, but it's getting annoying. Is there any way to change the initial start position of this box?
View 6 Replies View Relatedcan i connect to SAP from SSRS and execute reports?
View 1 Replies View RelatedCurrently we are unable to connect to analysis services and getting the below error
Element 'return' was not found.Line 5,position 2
What could be causing this?