 |
|
|
|
Next: Fx-PHP:URGENT
|
| Author |
Message |
External
Since: Feb 26, 2008
Posts: 7
|
(Msg. 1) Posted: Tue Feb 26, 2008 1:46 pm
Post subject: problem with connecting to sql server via a wireless application
Archived from groups: microsoft>public>sqlserver>clients (more info?)
|
|
|
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 |
|
| Back to top |
|
 | |
External
Since: Jan 15, 2007
Posts: 80
|
(Msg. 2) Posted: Wed Feb 27, 2008 9:11 am
Post subject: Re: problem with connecting to sql server via a wireless application [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
> 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 |
|
| Back to top |
|
| |
External
Since: Feb 26, 2008
Posts: 7
|
(Msg. 3) Posted: Wed Feb 27, 2008 11:17 am
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
>
> > 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
> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Jan 15, 2007
Posts: 80
|
(Msg. 4) Posted: Thu Feb 28, 2008 9:12 am
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
> 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" wrote in message
>>
>> > 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
>> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Feb 26, 2008
Posts: 7
|
(Msg. 5) Posted: Thu Feb 28, 2008 2:50 pm
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
>
> > 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" wrote in message
> >>
> >> > 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
> >>
> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Jan 15, 2007
Posts: 80
|
(Msg. 6) Posted: Fri Feb 29, 2008 9:17 am
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
> 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" wrote in message
>>
>> > 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" wrote in message
>> >>
>> >> > 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
>> >>
>> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Feb 26, 2008
Posts: 7
|
(Msg. 7) Posted: Fri Feb 29, 2008 4:35 pm
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
>
> > 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" wrote in message
> >>
> >> > 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" wrote in message
> >> >>
> >> >> > 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
> >> >>
> >>
> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Jan 15, 2007
Posts: 80
|
(Msg. 8) Posted: Mon Mar 03, 2008 9:36 am
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Since you now cannot ping the server from the client, you clearly have a
TCP/IP error. The SSPI (security support provider interface) error can also
be caused by network issues. For example, not being able to authenticate
your integrated connection information because the Kerberos authentication
server is unavailable or just can't be reached. There may be other errors in
the Windows Event logs to explain what's going on. You probably already
looked for that. I would try to solve the TCP problem next.
Other things, maybe SQL Server's Service Principal Name (SPN) isn't properly
registered with Active Directory (which assumes the role of the Kerberos Key
Distribution Center). Using Kerberos Authentication with SQL Server
http://msdn2.microsoft.com/en-us/library/cc280745(SQL.100).aspx
But I'm just fishing now.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hezal" wrote in message
> 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" wrote in message
>>
>> > 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" wrote in message
>> >>
>> >> > 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" wrote in message
>> >> >>
>> >> >> > 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
>> >> >>
>> >>
>> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Aug 28, 2007
Posts: 179
|
(Msg. 9) Posted: Fri Mar 07, 2008 11:32 pm
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Maybe, the user that you are trying to log into your SQL Server Instance is
not part of the domain and as you are using Windows Authentication as the
authentication mode and as the user is not the part of the domain, this
problem could be occuring because of this?
Have you tried using a SQL Login to log in to your SQL Server Instance? (In
this case, ensure your SQL Server Instance' s authentication mode is mixed)
--
Ekrem Önsoy
"Hezal" wrote in message
> 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" wrote in message
>>
>> > 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" wrote in message
>> >>
>> >> > 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" wrote in message
>> >> >>
>> >> >> > 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
>> >> >>
>> >>
>> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Aug 28, 2007
Posts: 179
|
(Msg. 10) Posted: Fri Mar 07, 2008 11:36 pm
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
> 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" wrote in message
>>
>> > 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" wrote in message
>> >>
>> >> > 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" wrote in message
>> >> >>
>> >> >> > 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
>> >> >>
>> >>
>> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Feb 26, 2008
Posts: 7
|
(Msg. 11) Posted: Sat Mar 08, 2008 11:00 am
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks for the replies.
Yes since I cant pinge the server IP from the device I need to investigate
more on the TCP/IP problem.
Also I can't change from Windows authentication to mixed mode to allow both
SQL and Windows authentication since I use SQL Server 2005 integrated with
Visual Studio 2005 and it doesn't have SQL Server Management Studio. All
searches I have done was explaining how to change the authentication mode
using Management Studio.
Also I am not familiar with this SQL and I don't know how to add a user for
the SQL Server in Visual Studio so I can specify that user's name and ID in
connection string.
I would appreciate any help.
Kind regards,
"Ekrem Önsoy" wrote:
> 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" wrote in message
>
> > 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" wrote in message
> >>
> >> > 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" wrote in message
> >> >>
> >> >> > 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" wrote in message
> >> >> >>
> >> >> >> > 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
> >> >> >>
> >> >>
> >>
>
> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Aug 28, 2007
Posts: 179
|
(Msg. 12) Posted: Sat Mar 08, 2008 9:37 pm
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hello Hezal,
There is a free tool which is called SQL Server Management Studio Express by
Microsoft. It's a limited version of full SSMS. But you can change your SQL
Server Instance' s Authentication Mode to Mixed using it. And you can easily
add a Login using it.
You can download it here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1...3d-94b8
--
Ekrem Önsoy
"Hezal" wrote in message
> Thanks for the replies.
>
> Yes since I cant pinge the server IP from the device I need to investigate
> more on the TCP/IP problem.
> Also I can't change from Windows authentication to mixed mode to allow
> both
> SQL and Windows authentication since I use SQL Server 2005 integrated with
> Visual Studio 2005 and it doesn't have SQL Server Management Studio. All
> searches I have done was explaining how to change the authentication mode
> using Management Studio.
>
> Also I am not familiar with this SQL and I don't know how to add a user
> for
> the SQL Server in Visual Studio so I can specify that user's name and ID
> in
> connection string.
>
> I would appreciate any help.
> Kind regards,
>
>
>
> "Ekrem Önsoy" wrote:
>
>> 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" wrote in message
>>
>> > 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" wrote in message
>> >>
>> >> > 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" wrote in message
>> >> >>
>> >> >> > 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" wrote in message
>> >> >> >>
>> >> >> >> > 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
>> >> >> >>
>> >> >>
>> >>
>>
>> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Feb 26, 2008
Posts: 7
|
(Msg. 13) Posted: Sat Mar 08, 2008 9:37 pm
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thank you soo much Ekrem
I will try that now..
"Ekrem Önsoy" wrote:
> Hello Hezal,
>
> There is a free tool which is called SQL Server Management Studio Express by
> Microsoft. It's a limited version of full SSMS. But you can change your SQL
> Server Instance' s Authentication Mode to Mixed using it. And you can easily
> add a Login using it.
>
> You can download it here:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1...3d-94b8
>
> --
> Ekrem Önsoy
>
>
>
> "Hezal" wrote in message
>
> > Thanks for the replies.
> >
> > Yes since I cant pinge the server IP from the device I need to investigate
> > more on the TCP/IP problem.
> > Also I can't change from Windows authentication to mixed mode to allow
> > both
> > SQL and Windows authentication since I use SQL Server 2005 integrated with
> > Visual Studio 2005 and it doesn't have SQL Server Management Studio. All
> > searches I have done was explaining how to change the authentication mode
> > using Management Studio.
> >
> > Also I am not familiar with this SQL and I don't know how to add a user
> > for
> > the SQL Server in Visual Studio so I can specify that user's name and ID
> > in
> > connection string.
> >
> > I would appreciate any help.
> > Kind regards,
> >
> >
> >
> > "Ekrem Önsoy" wrote:
> >
> >> 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" wrote in message
> >>
> >> > 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" wrote in message
> >> >>
> >> >> > 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" wrote in message
> >> >> >>
> >> >> >> > 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" wrote in message
> >> >> >> >>
> >> >> >> >> > 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
> >> >> >> >>
> >> >> >>
> >> >>
> >>
> >>
> >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Feb 26, 2008
Posts: 7
|
(Msg. 14) Posted: Tue Mar 11, 2008 6:45 am
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Yesssss It worked 
I installed the tool SQL Server Management Studio Express and I changed the
server's access mode to mixed mode. I've then added a user for the server,
assigned the necessary permissions for this user and changed the connection
string that includes this users id and password.
Thank you very again for all the help
"Hezal" wrote:
> Thank you soo much Ekrem
> I will try that now..
>
> "Ekrem Önsoy" wrote:
>
> > Hello Hezal,
> >
> > There is a free tool which is called SQL Server Management Studio Express by
> > Microsoft. It's a limited version of full SSMS. But you can change your SQL
> > Server Instance' s Authentication Mode to Mixed using it. And you can easily
> > add a Login using it.
> >
> > You can download it here:
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1...3d-94b8
> >
> > --
> > Ekrem Önsoy
> >
> >
> >
> > "Hezal" wrote in message
> >
> > > Thanks for the replies.
> > >
> > > Yes since I cant pinge the server IP from the device I need to investigate
> > > more on the TCP/IP problem.
> > > Also I can't change from Windows authentication to mixed mode to allow
> > > both
> > > SQL and Windows authentication since I use SQL Server 2005 integrated with
> > > Visual Studio 2005 and it doesn't have SQL Server Management Studio. All
> > > searches I have done was explaining how to change the authentication mode
> > > using Management Studio.
> > >
> > > Also I am not familiar with this SQL and I don't know how to add a user
> > > for
> > > the SQL Server in Visual Studio so I can specify that user's name and ID
> > > in
> > > connection string.
> > >
> > > I would appreciate any help.
> > > Kind regards,
> > >
> > >
> > >
> > > "Ekrem Önsoy" wrote:
> > >
> > >> 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" wrote in message
> > >>
> > >> > 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" wrote in message
> > >> >>
> > >> >> > 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" wrote in message
> > >> >> >>
> > >> >> >> > 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" wrote in message
> > >> >> >> >>
> > >> >> >> >> > 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
> > >> >> >> >>
> > >> >> >>
> > >> >>
> > >>
> > >>
> > >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
External
Since: Aug 28, 2007
Posts: 179
|
(Msg. 15) Posted: Tue Mar 11, 2008 5:29 pm
Post subject: Re: problem with connecting to sql server via a wireless applicati [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I'm glad it works =)
--
Ekrem Önsoy
"Hezal" wrote in message
> Yesssss It worked
> I installed the tool SQL Server Management Studio Express and I changed
> the
> server's access mode to mixed mode. I've then added a user for the server,
> assigned the necessary permissions for this user and changed the
> connection
> string that includes this users id and password.
>
> Thank you very again for all the help
>
>
>
> "Hezal" wrote:
>
>> Thank you soo much Ekrem
>> I will try that now..
>>
>> "Ekrem Önsoy" wrote:
>>
>> > Hello Hezal,
>> >
>> > There is a free tool which is called SQL Server Management Studio
>> > Express by
>> > Microsoft. It's a limited version of full SSMS. But you can change your
>> > SQL
>> > Server Instance' s Authentication Mode to Mixed using it. And you can
>> > easily
>> > add a Login using it.
>> >
>> > You can download it here:
>> > http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1...3d-94b8
>> >
>> > --
>> > Ekrem Önsoy
>> >
>> >
>> >
>> > "Hezal" wrote in message
>> >
>> > > Thanks for the replies.
>> > >
>> > > Yes since I cant pinge the server IP from the device I need to
>> > > investigate
>> > > more on the TCP/IP problem.
>> > > Also I can't change from Windows authentication to mixed mode to
>> > > allow
>> > > both
>> > > SQL and Windows authentication since I use SQL Server 2005 integrated
>> > > with
>> > > Visual Studio 2005 and it doesn't have SQL Server Management Studio.
>> > > All
>> > > searches I have done was explaining how to change the authentication
>> > > mode
>> > > using Management Studio.
>> > >
>> > > Also I am not familiar with this SQL and I don't know how to add a
>> > > user
>> > > for
>> > > the SQL Server in Visual Studio so I can specify that user's name and
>> > > ID
>> > > in
>> > > connection string.
>> > >
>> > > I would appreciate any help.
>> > > Kind regards,
>> > >
>> > >
>> > >
>> > > "Ekrem Önsoy" wrote:
>> > >
>> > >> 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" wrote in message
>> > >>
>> > >> > 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" wrote in message
>> > >> >>
>> > >> >> > 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" wrote in message
>> > >> >> >>
>> > >> >> >> > 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" wrote in message
>> > >> >> >> >>
>> > >> >> >> >> > 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
>> > >> >> >> >>
>> > >> >> >>
>> > >> >>
>> > >>
>> > >>
>> > >> Stay informed about: problem with connecting to sql server via a wireless appli.. |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
