Re: problem with connecting to sql server via a wireless applicati
- From: Hezal <Hezal@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 29 Feb 2008 16:35:00 -0800
Hi Rick,
Actually I have removed all the dynamic ports and enabled server to listen
to port 1433 and changed the connection string to the suggested format. Now
it listens the right port.
I also tried to ping the IP address of the server and I get request time
out message displayed.
The error I receive now is the following:
"Login failed for user ''. The user is not associated with a trusted SQL
Server connection."
here is the part of the log file showing the error:
008-03-01 00:00:32.56 Logon Error: 17806, Severity: 20, State: 2.
2008-03-01 00:00:32.56 Logon SSPI handshake failed with error code
0x8009030c while establishing a connection with integrated security; the
connection has been closed. [CLIENT: 127.0.0.1]
2008-03-01 00:00:32.56 Logon Error: 18452, Severity: 14, State: 1.
2008-03-01 00:00:32.56 Logon Login failed for user ''. The user is not
associated with a trusted SQL Server connection. [CLIENT: 127.0.0.1]
I think it now connects but has an issue with authentication, but I am
confused as when I try to ping the IP address of the server from the client
it seems like unreachable. I don't know what is wrong there :(
"Rick Byham, (MSFT)" wrote:
OK. Time to check the bonehead things..
Is the SQL Server Service started?
Did you restart SQL Server after enabling the remote connections?
Did you spell the name correctly?
More complicated things.
Since you enabled TCP, can you connect to the IP Address/port? Check the SQL
Server error log and confirm that SQL Server is listening on port 1433. Get
the IP address of the SQL Server computer. Then try to connect to the IP
address and port number in the format: 127.0.0.1,1433
like
"Data Source=127.0.0.1,1433;Initial
Catalog=MEDITERRANEAN_RESTAURANT_MANAGEMENT;Integrated Security=True;"
Can you ping the IP address from the client computer?
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hezal" <Hezal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:513F0102-38B0-444E-9F5A-6EFD3020C1CF@xxxxxxxxxxxxxxxx
Thanks for the reply Rick. I appreciate it :)
I tried your suggestion but it still gives error.
I realised while debugging the following message: "SQL Server does not
exist or access denied."
"Rick Byham, (MSFT)" wrote:
Sorry. I don't know much about Visual Studio.
My only other suggestion is to turn on the SQL Server Browser Service on
the
SQL Server computer. SQL Server Express listens on dynamic ports, and
it's
possible it is not using port 1433. Remove ",1433" from the string, and
the
Browser Service should provide the correct port, if it's not 1433.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Hezal" <Hezal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FB510836-1F18-4FDD-AEE3-E962DB82B325@xxxxxxxxxxxxxxxx
The string is automatically created by visual studio therefore when I
remove
one slash it complains about unrecognised escape sequence..
"Rick Byham, (MSFT)" wrote:
You have too many slashes. HEZAL-PC\\SQLEXPRESS should be
HEZAL-PC\SQLEXPRESS
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Hezal" <Hezal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1F5FCD5E-80FB-4C7E-A6A7-4770790B8A3E@xxxxxxxxxxxxxxxx
Hi,
I have created a SQL Server 2005 database in VS 2005 and I am using
windows
mobile to access directly to SQL Server.
I use Vista and Windows Mobile device centre for the connection
between
the
device and the PC.
I have enabled remote connections for TCP/IP and named pipes. I have
also
checked the firewall settings and made an exception for sqlsrv.exe
Building it is fine but When I debug the application, the status
says
deployed successfully then it gives me the following error :
SqlException was unhandled- int returnValue =
this.Adapter.Fill(dataTable);
When I comment out the line that calls this 'Fill' method the It
displays
the column heading but no data in it off course..
So I am very confused whether this is a connection error or not...
The code is automatically generated by visual studio.
The connection string I use is:
"Data Source=HEZAL-PC\\SQLEXPRESS,1433;Initial Catalog=MEDITERRANEAN
_RESTAURANT_MANAGEMENT;Integrated Security=True;"
Here is the stack trace:
at System.Data.SqlClient.SqlConnection.get_ServerVersion() at
System.Data.SqlClient.SqlConnection.Open() at
System.Data.Common.DbDataAdapter.QuietOpen() at
System.Data.Common.DbDataAdapter.FillInternal() at
System.Data.Common.DbDataAdapter.Fill() at
System.Data.Common.DbDataAdapter.Fill() at
Orders.MEDITERRANEAN__RESTAURANT_MANAGEMENTDataSet1TableAdapters.Customer_DetailsTableAdapter.Fill()
at Orders.Form1.Form1_Load() at System.Windows.Forms.Form.OnLoad()
at
System.Windows.Forms.Form._SetVisibleNotify() at
System.Windows.Forms.Control.set_Visible() at
System.Windows.Forms.Application.Run() at Orders.Program.Main()
Sorry for the information overload.. I need some help urgently as I
have
spent days reading searching but nothing helped :(
Can anyone help me please?
Thanks
- Follow-Ups:
- Re: problem with connecting to sql server via a wireless applicati
- From: Ekrem Önsoy
- Re: problem with connecting to sql server via a wireless applicati
- From: Ekrem Önsoy
- Re: problem with connecting to sql server via a wireless applicati
- From: Rick Byham, \(MSFT\)
- Re: problem with connecting to sql server via a wireless applicati
- Next by Date: Re: Using SQLCMD to test Connection
- Next by thread: Re: problem with connecting to sql server via a wireless applicati
- Index(es):
Relevant Pages
|
Loading
