Re: problem with connecting to sql server via a wireless applicati
- From: Ekrem Önsoy <ekrem@xxxxxxxxxxxx>
- Date: Fri, 7 Mar 2008 23:36:40 +0200
Also, if it's a smartphone or something... I'm not a smartphone developer, but as far as I know a smart phone can not be a part of the domain. So you can't use Windows Authentication to log on to your SQL Server Instance using Windows Authentication. So try using SQL Authentication to log in to your SQL Server Instance.
--
Ekrem Önsoy
"Hezal" <Hezal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:AE0C266F-3CF5-4EE0-B79D-32619D008287@xxxxxxxxxxxxxxxx
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:
- References:
- Prev by Date: Re: problem with connecting to sql server via a wireless applicati
- Next by Date: Re: SQL CODE
- Previous by thread: Re: problem with connecting to sql server via a wireless applicati
- Next by thread: Re: problem with connecting to sql server via a wireless applicati
- Index(es):
Relevant Pages
|
Loading
