November 18, 2009 at 10:10 pm
k_amalpasha (11/18/2009)
Thanks for that, I've got it to work, but now it always asks me for a password to connect to the server every time I reopen the front end on the client side.
What do you mean front end on the client side?
Do you mean SQL Server Management Studio?
If so, when connecting from the SSMS, are you get an authentication window as shown in the attachment?
As shown in the attachment image, choose Remember password option.
If I misunderstood about what you mean by front end, let me know ...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 19, 2009 at 12:51 pm
I have same problem before.
SQL 2005 express version default setting disable remote access. Try this code
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'remote access', 1
GO
RECONFIGURE
GO
November 19, 2009 at 5:52 pm
Hi,
Remote Connected were enabled.
My front end is Access.
The error is:
Connection Failed
SQL State:'28000'
SQL Server Error:18456
[Microsoft][ODBC Server Driver]login failed for user 'KAMAL\Guest'
the error message box only gives me the option to click 'ok', when I click 'ok' another box opens with the Server Name and a ticked check box called 'use trusted connection' and below it are windows logon details, if I untick the check box I am able to enter the SQL Server Authentication Details,and the error goes away, but then when I close and reopen the database the error happens again.
Thanks
November 19, 2009 at 7:01 pm
I could able to understand your issue, but can only say this.
In the Error Message I see login failed for KAMAL\Guest.
Why are you using this guest account,in most cases guest account has very few privileges.
Can you change that Login context from KAMAL\Guest to KAMAL\USERNAME (any UserName) for that you need to create that user in your OS (Windows) and in the SQL server assign add that windows login and give appropriate permissions..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 19, 2009 at 8:19 pm
See this is where I get completley lost. I don't understand the concept of users and where that is set because when windows loads up it automatically logs into SQL Server, and I have pre-set an SQL Server Authentication Username and set the check box in the SQL Server Management utility to remember password. So I don't understand Guest is coming up, even the Windows login is an Admin account not a Guest account.
Thanks
November 19, 2009 at 9:46 pm
k_amalpasha (11/19/2009)
See this is where I get completley lost. I don't understand the concept of users and where that is set because when windows loads up it automatically logs into SQL Server, and I have pre-set an SQL Server Authentication Username and set the check box in the SQL Server Management utility to remember password. So I don't understand Guest is coming up, even the Windows login is an Admin account not a Guest account.Thanks
What is the application you are using, you say windows loads up it automatically logs into SQL Server.
Is your client machine (where application is installed and you refer) is windows XP machine? If so,how are logged in to that XP machine, it does not ask any Username / Pwd to login?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 19, 2009 at 10:04 pm
Client Machine: Win Xp Pro
Login: With User Name & Password (Admin Account)
I am just guessing that SQL server is logged into at startup. I am not quite sure, because even if I log in via the SQL Management Utility, still I get the same issue.
November 19, 2009 at 10:10 pm
Don't get impatient, by seeing the questions, since more details can only enable me to be solve the issue.
Now when you login to the XP machine, what application you use (that is using the SQL Server),can you take a screen shot and post as an attachment here?
If possible the SQL Server Management Studio Initial Login Screen screen shot where, you select SQL Login and give Username / Pwd.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 19, 2009 at 11:51 pm
Hi Bru,
I have attached the requested screenshot of SQL mgt utility 05 + some other screenshots you may find usefull (total of 3 screenshots with short narrative)
Thanks
November 20, 2009 at 12:08 am
Hi,
I think the connection properties from Access to SQL Server have to be set, I found this steps in Microsoft office web site. Give a try and let's see if it can solve.
http://office.microsoft.com/en-us/access/HP052745861033.aspx
Hope this works..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 20, 2009 at 2:05 pm
.....................
November 22, 2009 at 7:41 pm
Hi Bru,
I have tried connecting with a front end MS Access app with a *.adp file type, but I can't migrate the queries from the *.mdb file type to the *.adp file type. Then I converted the *.mdb file type to an *.accdb file type (this is the file type that has replaced *.adp file type)
After succesfully converting to the *.accdb file type I opened the application and encountered the same error I was having with the *.mdb file, so I suspect it is not the file type that is causing the error.
November 22, 2009 at 10:30 pm
Well, do you have some one from application team to help setting connection properties?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 22, 2009 at 10:40 pm
No, I am the application team
Viewing 14 posts - 16 through 28 (of 28 total)
You must be logged in to reply to this topic. Login to reply