Database connection error while connecting to database

Posted by veenavanimc-26861 under C# on 5/14/2014 | Points: 10 | Views : 927 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I am trying to connect the my project to the Database i have created. I entered Server name, Login credential, Database name. Established a test connection, test connection is successfully, Then I clicked on OK button, I am getting error as

"this server version is not supported you must have microsoft sql 2005 beta 2 or later"

Please help me out to resolve this problem.

Veena.M.C

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Sheonarayan on: 5/14/2014 [Administrator] HonoraryPlatinum | Points: 25

0	As the error suggest, it is telling to have later version of SQL Server. By the way, which application you are trying to connect to? SQL Server 2005 is very old database, the current version is Sql Server 2014. Regards, Sheo Narayan http://www.dotnetfunda.com veenavanimc-26861, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: veenavanimc-26861 on: 5/14/2014 [Member] Starter | Points: 25

0	Actually I am using SQL 2008. but error is displaying as use SQL 2005 beta 2 version Veena.M.C veenavanimc-26861, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sheonarayan on: 5/14/2014 [Administrator] HonoraryPlatinum | Points: 25

0	How is your connecction string looking like, the typical database connection looks like below <add name="LogDatabase" connectionString="Data Source=My-PC;Initial Catalog=MydatabaseLog;User ID=dnf;Password=dnf;" /> See if your database connection string is proper. Regards, Sheo Narayan http://www.dotnetfunda.com veenavanimc-26861, if this helps please login to Mark As Answer. \| Alert Moderator

How is your connecction string looking like, the typical database connection looks like below

<add name="LogDatabase" connectionString="Data Source=My-PC;Initial Catalog=MydatabaseLog;User ID=dnf;Password=dnf;" />

See if your database connection string is proper.

Regards,
Sheo Narayan
http://www.dotnetfunda.com

veenavanimc-26861, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: veenavanimc-26861 on: 5/14/2014 [Member] Starter | Points: 25

0	what we need to pass for "name" attribute in above connectionString Veena.M.C veenavanimc-26861, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sheonarayan on: 5/14/2014 [Administrator] HonoraryPlatinum | Points: 25

0	name is an identifier for this connectionString in the web.config file. var connStr = System.Configuration.ConfigurationManager.ConnectionStrings["LogDatabase"].ConnectionString; It has nothing to do with the database connectivity. Regards, Sheo Narayan http://www.dotnetfunda.com veenavanimc-26861, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts