AutoCAD Plant 3D General DIscussion

AutoCAD Plant 3D General DIscussion

Reply
Active Contributor
36 Posts
2 Kudos
Registered: ‎10-10-2011
Post 1 of 4
Accepted Solution

Connection Failed

1423 Views, 3 Replies
08-09-2012 09:30 PM

Hello everyone,

 

I am haveing troubles setting up a project to use MS SQL. When I create a new project (or try and convert one) I go through all the prompts until I get to the screen that lets me choose the database type. When I press the downwards arrow to select the SQL server, it automatically detects about 12 SQL servers running on the network. I select the correct one (the one I want to use) and press "Test Connection" Each time I get the same error message:

 

 

Connection Failed

Your test connection to the specified server has failed. Please try again.

 

You can see in the image that the Server is actually working, (SQL Management studio connecting into the server, on another physical machine). It is the only instance of SQL running on the server and a clean install of the server (SQL and OS).

 

This error also happens to all other SQL servers that I attempt to connect to (even the one on my workstation) and even happens across multiple workstations. Does anyone know of a solution for this?

 

Plant 3D 2013 Premium

Windows 7 x64

I have solved this about an hour ago (after days of head aches trying to get it going!)

 

To start I installed DotNet (.Net) version 4 This may or may not have been what made it work, I was promted to do this after reading an Microsoft Document on SQL and .Net The document explained that progrmas require the same .Net version in order to comunicate over TCP/IP. And it would seem that AutoCAD 2013 uses .Net 4 (as it is installed as a prerequisite) and SQL 2008 R2 uses (as defualt) .Net 3.5

 

Afterwards I installed the role/service of IIS 7

 

Inside of IIS 7 I created a Database connection string to the Master Database.

And then I also had the Windows Authenticaiton Enabled as well as Anonymous Authentication.

After a reboot, AutoCAD Plant 3D gave me a false positive (same as the image posted before) but this time was able to connect to the server and make the databases.

 

I will post a more detailed version with screen shots when I can get some more time.

Valued Contributor
64 Posts
4 Kudos
Registered: ‎11-22-2010
Post 2 of 4

Re: Connection Failed

08-15-2012 08:01 PM in reply to: ashley.walker

Hi ashley, have you tried looking at this website as your guide?

 

http://www.davetyner.com/au-2011-classes/autocad-plant-3d-sqlite-to-microsoft-sql-server-%C2%AE-jaso...

 

 

Active Contributor
36 Posts
2 Kudos
Registered: ‎10-10-2011
Post 3 of 4

Re: Connection Failed

08-15-2012 08:52 PM in reply to: neonade

I have solved this about an hour ago (after days of head aches trying to get it going!)

 

To start I installed DotNet (.Net) version 4 This may or may not have been what made it work, I was promted to do this after reading an Microsoft Document on SQL and .Net The document explained that progrmas require the same .Net version in order to comunicate over TCP/IP. And it would seem that AutoCAD 2013 uses .Net 4 (as it is installed as a prerequisite) and SQL 2008 R2 uses (as defualt) .Net 3.5

 

Afterwards I installed the role/service of IIS 7

 

Inside of IIS 7 I created a Database connection string to the Master Database.

And then I also had the Windows Authenticaiton Enabled as well as Anonymous Authentication.

After a reboot, AutoCAD Plant 3D gave me a false positive (same as the image posted before) but this time was able to connect to the server and make the databases.

 

I will post a more detailed version with screen shots when I can get some more time.

Member
3 Posts
0 Kudos
Registered: ‎02-23-2008
Post 4 of 4

Re: Connection Failed

11-16-2013 05:11 AM in reply to: ashley.walker

Ashley

 

Could you post you solution, we are having the same problem but not getting the databases generated. A bit more detail on the IIS 7 service would help.

 

 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Plant 3D Category!

The AutoCAD Plant 3D forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!