October 11, 2008 at 3:51 am
I have been developing in Access for 14 years and now have a client who wants a database to link to SQL Server 2005, copy tables and run M.I.S. reports. I downloaded a free 6-month Evaluation copy of SQL server 2005 and loaded it on to my pc. After some trials and tribs, I managed to do what was expected, yesterday. Today, I can't even connect to the Server. I have tried all combinations of Windows / SQL logins, etc., to no avail. Nothing else related to the SQL Server works either, presumably coz I can't connect to it, including giving myself admin permissions in Configuration. None of the Help files and Tutorials cover this eventuality, except to say "Start the server first!" - except that is is started - I just can not connect to it!
The message I [sometimes] get says [inter alia] "Default settings do not allow remote connections", but I can find no clue how to change the Default settings, or that the attempt to connect has timed out [10060]
I am running Vista Home Premium
Any clues towards a swift resolution appreciated
Dave B.
Hove
October 11, 2008 at 4:50 am
-you need to enable tcpip protocol using Sql server configuration manager.
(sql2005 network configuration for you rinstance)
-your client box needs to configure its firewall to be able the connect using the needed ports.
- to ease the access data migration to sql2005, MS published a migration assistent for Access. (free !)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 11, 2008 at 5:04 am
Thanks for your reply. I opened my Config Manager / Network Config Protocols for MSSQLSERVER and TCP/IP is already enabled, as are all the IP addresses in that 2nd tab. TCP/IP is similarly also enabled in the Client Config.
Please clarify how I can amend "client box needs to configure its firewall to be able the connect using the needed ports", as I don't see that option.
I appreciate the tip about the MS guide to data migration but, if I understand that expression correctly, I'm not trying to migrate any data, simply link an SQL Server backend to an Access front-end.
Many thanks
Dave B.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply