Connect Sqlserver
Oct 16, 2007i can't connect sqlserver from client pc
please help me >>>>>>>>>>>>>>>>>>
hi all
ADVERTISEMENT
Sqlserver Does Not Connect
Feb 17, 2006when sqlcmd -s serverinstance cmd is given it geves an error that "under default settings sql server does not allow remote connections login timeout expired"
why sql browser not running
pls help
Cannot Connect To SQLServer 2005
May 14, 2007After several attempts to install SQL2005 I finally got Microsoft SQL Server Management Studio installed.But now I get the error below: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) (.Net SqlClient Data Provider)The sa account username/password are correct and don't work, windows authentication does not work, I have stopped/started all the services, I have all Protocols enabled correctly, I have my Firewall turned off. Is there anything else I can try? Anything!
View 1 Replies View RelatedAttempting To Connect To SQLServer 2k
Aug 9, 2004This is the code I'm using on the web page located on the server:
Dim strConn as String
Dim conn as SQLConnection
strConn="server=localhost;Trusted_Connection=Yes;database=CIS"
conn=New SQLConnection(strConn)
conn.Open()
and the error messgae I receive is: Login failed for user 'MSP00427ASPNET'.
msp00427 is the name of the server
= = = = = = = = =
I have an MSAccess application that accesses the same database as follows with no trouble.
glblConnectString = "Driver=SQL Server;Server=msp00427;Database=CIS;Trusted_Connection=Yes"
Set cnn = New ADODB.Connection
cnn.Open glblConnectString
Set cmd = New ADODB.Command
cmd.ActiveConnection = cnn
cmd.CommandText = "Scorecard_Delete_ATLASDataDump"
cmd.CommandType = adCmdStoredProc
cmd.Execute
This is run on my PC and I have sa capabilities on the server.
The .NET framework is installed.
Any ideas why the data access on the web page fails?
Can I Connect Asp 1 To Sqlserver 2005
Oct 18, 2005Hi All,I hopen this isnt a stupid question but can I connect asp 1 to sqlserver 2005? i want to update the database used on a ASP.net 1 project, I seem to be able to get it to connect but cant get it to see the tables?Thanks for any helpLee
View 5 Replies View RelatedUnable To Connect To Sqlserver
Dec 31, 2007unable to connect to sqlserver, server not found error ... i typed the right username and password,,, still i am not able to connect to sqlserver ,,also i tried with new sqlserver registration still i am not able to connect to sqlserver
error :
specified sqlserver not found connection connect()
please help me out
I Cannot Connect To SQLSERVER Database
Jul 23, 2007In SQLserver Admin, ANDONASPNET is setup as a 'Server Admin'
****************************************************************************
Connection string is set in the web.config file.
<configuration>
<connectionStrings>
<add name="SqlServerEx"
connectionString="Data Source=LOCALHOSTSQLEXPRESS;Initial Catalog=DB2;Integrated Security=SSPI;"
providerName="System.Data.SqlClient;"></add>
</connectionStrings>
<appSettings/>
<system.web>
.......................................................................
protected void Button2_Click(object sender, EventArgs e)
{
string connStr = WebConfigurationManager.ConnectionStrings["SqlServerEx"].ConnectionString;
SqlConnection con = new SqlConnection(connStr);
TextBox3.Text = connStr;
try
{
con.Open();
TextBox2.Text = "<b> Server Verison::</b>" + con.ServerVersion;
TextBox2.Text += "<br /><B>Connection Is::</B> " + con.State.ToString();
}
catch (Exception err)
{
TextBox2.Text = "Error reading Database. ";
TextBox2.Text += err.Message;
}
finally
{
con.Close();
TextBox2.Text += "<BR><B>CONNECTION::" + con.State.ToString() + "</B>";
}
}
****************************************************************************
This is the error message I am getting:
"Error reading Database. Instance failure."
Connect To SqlServer 2005 With Odbc
Feb 28, 2008Hi all,
I'm not a db guru and probably this is a very simple question for you, but I was wondering if it was possible to connect to a SqlServer using odbc without DSN.
I mean, I'm trying to connect to the db server from a linux (Fedora Core 8) workstation, using odbc drivers, but it looks like I can do that only using a DSN connection and setting properly the odbc.ini file. It doesn't work, if I use a connection like this from a PHP script:
$cn = odbc_connect("Driver={SQL Server};Server=MyServer;Database=MyDatabase",
"MyUser","MyPassword")
Does anyone know how to connect to SqlServer with a DSN-less connection? Could you explain me where is the error?
I'm using SQLServer2005, Fedora Core 8 with the last FreeTDS installed.
Please help!
Thanks million in advance.
Failed To Connect To Sqlserver 2005
Jun 25, 2007Hi
im trying to connect to sqlserver 2005 using windows authentication and gives me this error "Login failed for user ''. The user is not associated with a trusted SQL Server connection."
any help
thanks in advance.
When I Connect SqlServer Db I Got The Specified Network Name Is No Longer Available.
Dec 28, 2007
Hi.
i got an error when i connect to sqlserver 2005 db with use of Sqlserver ManagementStudio.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)(Microsoft Sql Error - 64)...
Connect To Sqlserver By Sqlconnection From Windows CE 5.0
Feb 6, 2007Currently I cannot connect to a database, I got the system.exception €œPlatformNotSupportedExcoption€?. This database is Polish (COLLATE Polish_CI_AS), when I collate this database to latin general it works fine. I connect by using the system.data.sqlclient.sqlconnection, as far as I can see I cannot set the locale identifier here€¦ What can I do???
Thanks for your help!
regards, Jan
Error When Connect To Sqlserver From Another Machine
Nov 17, 2006hi ..
i install sqlserver and make app with vb6 using ADO to connect to the database and successfully
i put that application on another pc on the network
when i open it it says "can't login computernameguest" ??!!
any help
thanks in advance.
How To Connect To My Web-Site'SqlServer Through Enterprise Manager?
Aug 19, 2006Hi all,
I have Sql Server 2000 installed in my home and also i have a website that works with Sql Server2000 and .Net FrameWork v1.1 ,now i want to know is it possible to connect from my home SqlServer to Host SqlServer( where my Website resides ) through Enterprise manager or Query Analizer to do some data-manipulation And how?
Thanks in advance.Regards.
Why Can't I Connect To SQLServer With An Incomplete Conn. String ?
Dec 23, 2004I found out that I could use SQLDMO to enumerate objects in a SQL server. However, I can't connect to my server, even though I have both "windows and SQL server" authentication on "(local) Windows NT".
Here is the code (it does not contain the validation in this snippet):
Imports System.Data.SqlClient
Imports SQLDMO
Public Class ADO_2
Inherits System.Web.UI.Page
Protected WithEvents txtQuery As System.Web.UI.WebControls.TextBox
Protected WithEvents txtresults As System.Web.UI.WebControls.TextBox
Protected WithEvents lstDB As System.Web.UI.WebControls.DropDownList
Protected WithEvents lblResult As System.Web.UI.WebControls.Label
Protected WithEvents cmdExecute As System.Web.UI.WebControls.Button
Protected WithEvents cmdNext As System.Web.UI.WebControls.Button
Private m_objConn As New SqlConnection()
Private m_objSQLServer As SQLDMO.SQLServer
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
EnumerateDatabases()
'TEMP
lstDB.Items.Add("Northwind")
lstDB.Items.Add("Pubs")
'END TEMP
End Sub
Private Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Unload
m_objConn.Close() 'Just in case.....
End Sub
Private Sub cmdExecute_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExecute.Click
Dim objCommand As SqlCommand
Dim objDataReader As SqlDataReader
Dim intField As Integer
txtresults.Text = String.Empty
m_objConn.ConnectionString = "server=radu;database=" & lstDB.SelectedItem.Text & ";integrated security=SSPI;"
m_objConn.Open()
objCommand = New SqlCommand(txtQuery.Text, m_objConn)
objDataReader = objCommand.ExecuteReader
While objDataReader.Read
txtresults.Text &= vbNewLine
For intField = 0 To objDataReader.FieldCount - 1
txtresults.Text &= objDataReader(intField).ToString.PadRight(15)
Next
End While
objDataReader.Close()
objDataReader = Nothing
objCommand = Nothing
m_objConn.Close()
End Sub
Private Sub EnumerateDatabases()
On Error GoTo EnumerateDatabasesError
Dim objSQLDatabase As SQLDMO.Database
m_objSQLServer = New SQLDMO.SQLServer()
m_objSQLServer.Connect("radu")
'Iterate through all databases on the target server:
For Each objSQLDatabase In m_objSQLServer.Databases
lstDB.Items.Add(objSQLDatabase.Name)
Next objSQLDatabase
EnumerateDatabasesExit:
objSQLDatabase = Nothing
m_objSQLServer.Close()
m_objSQLServer = Nothing
Exit Sub
EnumerateDatabasesError:
lblResult.Text = Err.Number.ToString & ", " & Err.Description
Resume EnumerateDatabasesExit
End Sub
End Class
Why can't I connect with m_objSQLServer.Connect("radu") ? I also tried m_objSQLServer.Connect("radu", "", ""). Otherwise, I can connect just fine with m_objConn.Open() (after I select a db from the dropdownlist, which is for now populated by hand)....
Thanks a lot for your time.
Alex.
Can't Connect To DB When SqlServer Exp Has Been Idle For A Couple Hours.
Mar 13, 2008Does SQLServer go to sleep when it's been idle? How can I connect without an error?
I have SQLExpress on a server. Server Name is SqlExpress. I have 2 DBs on that server... Tuna & Guppy. I'm connecting to the DBs from a remote PC which runs my App... an exe created with Visual Studio 2008, Visual Basic.
If I run my App at say 9:30PM, after the server has been idle for several hours, I get a "Can't open connection to Guppy" error, which is my error message when the connection attempt fails. If I quit & relaunch the app, it connects fine, and will continue connecting fine unless you leave the server idle for serveral hours again.
If I'm developing a 2nd app all evening... which connects to a 2nd DB...Tuna, that activity seems to keep the SqlServer awake and then launching the 1st app at 9:30PM connects to Guppy just fine.
I tried adding a "Connection Timeout=30" to my connection string but that did not help.
My connection code is as follows (note the server's name is SQLExpress):
Dim strConnG As String = "Data Source=SQLEXPRESSSQLEXPRESS;Initial Catalog=Guppy;Integrated Security=True;Connection Timeout=30"
Using ConnG As New SqlConnection(strConnG)
'open Guppy connection
Try
ConnG.Open()
Catch ex As Exception
MsgBox("Can't open connection to guppy")
Return False
End Try
'Code that does stuff
End using
Can anyone tell me how to fix this so I can connect without error, even if the server has been idle?
Thank you,
Joe A
Connection String To Connect To SQLServer Express?
Feb 22, 2006Hi
I've been trying to get DotNetNuke to connect to a SQLServer Express database but no luck. I've had no luck with info from their forums...
The connection string I'm supposed to use is:
<add
name="SiteSqlServer"
connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" />
I just can't get it to connect to the database. Says something that remote connections are not allowed. I've done the Area thing and allowed all connection including remote connections.
Can't we use the standard string like:
<add
name="SiteSqlServer"
connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
providerName="System.Data.SqlClient" />
...to connect? I'd like to setup a user and give the username and password in the connection string - real easy and non-complicated...
Any ideas or help?
Andre
Unable To Connect To Sqlserver 2000 From Sqlserver2005
Sep 10, 2007
Hi,
iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Unable to connect to Sqlserver 2000 which is installed remotely ....Sqlserver2000 is dev edition.i cudnot find Sqlserver2000 instance when i try to search for Network database engine name .......
I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine
Coneverting Oledb Code To Connect To Remote Sqlserver
Sep 28, 2007i have some oledb code made in c#(vs 2005) it is for local msaccess file. i want to conevert the code for sql server where connection string placed in web.config file seperately. please help me.here is code private void buildGrid()
{
string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
conStr += Server.MapPath("~/common/db/demo.mdb");
System.Data.OleDb.OleDbConnection dbCon = new System.Data.OleDb.OleDbConnection(conStr);
dbCon.Open();
string sql = "SELECT * FROM Posts ORDER BY LastPostDate DESC";
System.Data.OleDb.OleDbDataAdapter dbAdapter = new System.Data.OleDb.OleDbDataAdapter(sql, dbCon);
DataSet ds = new DataSet();
dbAdapter.Fill(ds);
ds.Tables[0].TableName = "Inbox";
Grid1.DataSource = ds;
}
please healp me..
How Can I Connect To Sqlserver Express Manually When I Use Text Boxed
Feb 27, 2006hi guys,
i am very happy that i found this forum which discuss ASP.net.i am new to ASP.net 2.0 and some need serious help. when i debug my application and try to insert data an error occur saying:"Cannot open database "ecb" requested by the login. The login failed. Login failed for user 'HOME-USERuser'."the code that i have used to submit data is as follow:Imports System.Data.SqlClient... Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim objConn As SqlConnection Dim objCmd As SqlCommand
objconn = New SqlConnection("data source= localhostsqlexpress; initial catalog =ecb; persist security info =true; trusted_connection=true")
objCmd = New SqlCommand("INSERT INTO staff (firstname, surname) VALUES (@firstname, @surname,)", objConn)objCmd.Parameters.Add("@FirstName", Data.SqlDbType.VarChar).Value = txtFirstName.TextobjCmd.Parameters.Add("@Surname", Data.SqlDbType.VarChar).Value = txtSurname.TextobjConn.Open()objCmd.ExecuteNonQuery()objConn.Close()
i also used this data connection but didn't help: objconn = New SqlConnection("Server=localhost; Database=ecb;user ID=' ';Password=' ' ") when i use this data
connection i get this message: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
as far as i can remember i have used windows authentication when creating my database in sql server 200 express edition.
the funny thing is that when i use datagrid wizard or dataform the connection is fine ( i mean is automatically done for me but i don't know when i like to do it manually does not work).can anyone help? thank you in advanced
How To Connect With SqlServer 2000 In Pocket PC 2003 Application.
Oct 31, 2007How to Connect sqlServer 2000 in Pocket PC 2003 Application.
In Packet PC 2003 Application I have to connect to sql server 2000 on
my machine. The application gives error if connected using sqlConnection. Is SQL server CE necessary to connect to sql server 2000 in .Net Compact Framework?
How Do You Connect To Networked SqlServer 2005 Express Using The Add New Data Source Wizard
Sep 7, 2006Hi All,
I want to connect to SQLExpress database on the network. I can do so using code but I want to use the Data Source Configuration Wizard. It seems this only works for local instances of SQL server. Is this true?
I can connect just fine to the database on the network using Microsoft SQL Server Management Studio Express...for what this is worth.
I have tried to map a drive to the SQL server machine and pick the mdf file but I get the error msg of network path is not supported for database files....I have turned on allow remote connections, allow tcp/ip, named pipes, added sqlserv.exe and sqlbrowser.exe to my firewall exceptions ect..
I want to be able to use Table Adapters, SqlDataAdapters ect. After reading numerous forum questions/ kb articles this seems to be a common problem. I am on the verge of just saying forget it and use MS Access instead.
Thanks in advance!
Connect To SQLserver In Peer-To-Peer Env.
May 14, 2007I have a few machines set in a workgroup which I want to use for testing SQL Server but I don't seem to be able to connect to an instance from a peer client. I can ping the machine and removed the firewall and can remote desktop.
any advice, thanks
Class Method Is Smoking Fast When Executed Outside Of SQLServer, Dog Slow As A CLR Function Is SQLServer - Anyone?
May 10, 2007We have a static class that makes an HTTPWebRequest to get XML data from one of our vendors. We use this as input to a stored proc in SQLServer2005. When I compile this class and call it from a console application in visual studio it executes in milliseconds, everytime. When I compile it, create the assembly and clr function and execute it in SQLServer, it takes around 14 seconds to execute the first time, then on subsequent requests it is again really fast, until I wait for 10 seconds and re-execute, once again it is slow the first time and then fast on subsequent requests. We do not see this behavior when executing outside SQLServer. Makes me think that some sort of authentication is perhaps taking place the first time the function is run in SQLServer? I have no idea how to debug this further. Anyone seen this before or have any ideas?
Here is the class:
Code Snippet
using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;
namespace Predict.Services
{
public static class Foo
{
public static string GetIntradayQuote(string symbol)
{
string returnQuote = "";
HttpWebRequest request = (HttpWebRequest)(WebRequest.Create("http://data.predict.com/predictws/detailed_quote.html?syms=" + symbol + "&fields=1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,28,30"));
request.Timeout = 1000;
HttpWebResponse response = (HttpWebResponse)(request.GetResponse());
StreamReader streamReader = new StreamReader(response.GetResponseStream());
returnQuote = streamReader.ReadToEnd();
streamReader.Close();
response.Close();
return returnQuote;
}
}
}
When I run call it from a console app it is fine.
I compile it into a dll and then create the assembly and function as follows:
Code Snippet
drop function fnTestGetIntradayQuoteXML_SJS
go
drop assembly TestGetIntradayQuoteXML_SJS
go
create ASSEMBLY TestGetIntradayQuoteXML_SJS from 'c:DataBackupsCLRLibrariesTestGetIntradayQuote_SJS.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS
go
CREATE FUNCTION fnTestGetIntradayQuoteXML_SJS(@SymbolList nvarchar(max)) RETURNS nvarchar(max) AS EXTERNAL NAME TestGetIntradayQuoteXML_SJS.[Predict.Services.Foo].GetIntraDayQuote
go
declare @testing nvarchar(max)
set @testing = dbo.fnTestGetIntradayQuoteXML_SJS('goog')
print @testing
When I execute the function as above, again, really slow the first time, then fast on subsequent calls. Could there be something wrong with the code, or some headers that need to be set differently to operate from the CLR in SQLServer?
Regards,
Skipper.
Problem Unicode Data 0x2300 In SQLServer 2000 SQLServer 2005 Express
Sep 20, 2006Hi experts;
I have a problem with unicode character 0x2300
I created this table
create table testunicode (Bez nchar(128))
Insert Data
insert into testunicode (Bez)values('Œ€„¢')
with 2 Unicode characters
Œ€ = 0x2300
„¢ = 0x2122
Selecting the data
select Bez from testunicode
I see
"?„¢"
„¢ = 0x2122 is ok but instead of 0x2300 there is 0x3f
When I modify the insert statement like that ( 8960 = 0x2300 )
insert into testunicode (Bez)values(NCHAR(8960)+'„¢')
and select again voila i see
"Œ€„¢"
Does anyone have an idea?
Thanks
Trying To 'load' A Copy Of A SQLServer 2000 Database To SQLServer 2005 Express
Apr 18, 2008
I am trying to 'load' a copy of a SQLServer 2000 database to SQLServer 2005 Express (on another host). The copy was provided by someone else - it came to me as a MDF file only, no LDF file.
I have tried to Attach the database and it fails with a failure to load the LDF. Is there any way to bypass this issue without the LDF or do I have to have that?
The provider of the database says I can create a new database and just point to the MDF as the data source but I can't seem to find a way to do that? I am using SQL Server Management Studio Express.
Thanks!!
MIcrosft SQLServer Best Practices Document On Securing SQLServer
Jul 29, 2005I'm chasing after a documetn that was available on one of the Microsoftwebsites that was titled somethign like "MS SQL Server Best Practices"and detailed a nyumber of best practices about securing the server.Included in this was revoking public access to the system tableobjects.Can someone post the URL where I can pick this up, or drop me a note oncontacting them for a copy of the document?
View 2 Replies View RelatedReplacing Sqlserver 2000 With Sqlserver 2005 Express
Jun 14, 2006I have an app that uses a sqlserver 2000 jdbc driver to connect to a sqlserver 2000.
Is it possible to do a direct replacement of sqlserver 2000 with sqlserver 2005 express just by reconfiguring the app to point to the express? The app would still be using the sqlserver 2000 jdbc driver to try and make the connection.
If that is a possibility, what can be some differences in the configuration? Previously with 2000 the config information I entered is:
server name: "machinename"( or ip). I've also tried "machiname/SQLEXPRESS"
DB name: name of db instance
port: 1433(default)
user and pass.
My attempts so far results in
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket."
and
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL."
Upgrade SQLServer Mobile (.sdf) Database To SQLServer 2005
Feb 9, 2006Hello,
I have an SQLServer Mobile database, and I would like to know if there is a way to upgrade it to SQLServer 2005 (.mdf) database. My database has no records in it, just the structure (tables etc). What I am actually asking is if I can create automatically a new SQLServer 2005 Database with the same structure as my existin SQLSErver Mobile database
Thanks in advance,
TassosTS
SQLSERVER 2005 X64 Linked Server To SQLSERVER 7.0
Jun 20, 2007Hello people.
I am in the process of planning a server upgrade to sql2005 x64.
I created 2 linked servers: one to a SQL2000 sp4 server and one to a SQL7.0 SP3.
I have the following error when I query the linked servers.
OLE DB provider "SQLNCLI" for linked server "IVDM2K" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "IVDM2K" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "IVDM2K". The provider supports the interface, but returns a failure code when it is used.
I am aware of KB 906954.
http://support.microsoft.com/default.aspx?scid=kb;en-us;906954
I applied the instcat.sql on the SQL2000SP4 server and my linked server issues for that one are gone.
However, I ran the instcat.sql script on the SQL7.0 sp3 server and the linked server is still giving me an issue.
Can someone help me find a solution to this?
Post Update For SQLServer SP2--is There One For SQLServer Express?
Apr 18, 2007Regarding KB935356, is there a "post" service pack 2 update for SQLServer Express?
Thanks.
How To Import Access To SQLServer With Parameter From SQLServer, Help Pls!
Jul 8, 2006Hello Expert!
I have 2 Database €“ Access & SQLServer(ver 7)
I need to Import Data TblShift from Access to SQLServer €“ using DTS I€™ve done this successfully!
Now I want to use parameter so I only importing record within range (e.g. ShiftDate BETWEEN 05-24-2006 AND 06-23-2006)
In SQLServer, I have created table to store the date range as following:
TblParameter
DateFrom: 04/24/2006
DateTo: 05/23/2006
How do I use the date range from TblParameter(SQLServer) to import record from TblShift(Access) using DTS?
Is this possible or any better solution for this?
TIA
Regards,
Differences Between Sqlserver 2000 And Sqlserver 7.0
Dec 29, 2005Hi Friends,
Can some please let me know the differences between sqlserver 2000 and sqlserver 7.0
Difference In SQLSERVER/sqlExpress And SQLSERVER
Jun 6, 2007Hi,
I am new to SQL Server 2005. I tried connecting to my local machine by using my machine name as Server name and then tried running the following query:
SELECT * FROM SYS.Objects. It gives me following error:
Invalid object name 'sys.objects'.
Whereas, if I connect to my local machine using mahcinenameSQLEXPRESS, then the above mentioned query runs fine.
Why is this difference? What is the difference when I login in these 2 different ways.
Any help would be appreciated.
Thanks in advance.
Any help