Re: problem with connecting to sql server via a wireless applicati

Tech-Archive recommends: Speed Up your PC by fixing your registry

Yesssss It worked :D
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-4e3d-94b8-5a0f62bf7796

--
Ekrem Önsoy



"Hezal" <Hezal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F7F958DC-BE72-4EC0-82EF-1D986452578D@xxxxxxxxxxxxxxxx
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" <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






.

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... I believe the complete Windows auth user access is too complicate, ... which trusted connection is meant? ... it would still be listening on the old port. ... Microsoft, SQL Server Books Online ...
    (microsoft.public.sqlserver.connect)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
    (microsoft.public.sqlserver.setup)
  • Re: Sql Remote Connection issue
    ... port 1433 TCP Allow ... Copyright 2006 Microsoft Corporation. ... osql does not support all features of SQL Server 2005. ... Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2005 Connection Problems
    ... - it is't completely clear what the SQL Server Browser is for. ... connection reqest was being rejected. ... I think the problem is still likely the the port is blocked by some ... firewall between the server and that client. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
    ... enable network communication ... make sure that the port isn't blocked ... "An error has occurred while establishing connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.sqlserver)