Hi Frends iam have problems with connect RMS to SQL:
Have SMB 2003 Server, SQL 2005
but put in SO Administrator: Server: [local] | SQL Server Aut.: User: sa, Pass: same in sql | database: empty (or rmssample) but have these error:
Invalid connection, specific SQL Server not found
Please Help
I think server name should be (local) not [local]
Regards, Arthur
Dear Arthur Iam change to [local], also change to name of SQL Server SERVER/SQLEXPRESS, iam create user sa in SQL, with all grants, and create databe manually rmsspample but not work the connection see: specific SQL server not found, or access denaid,
Thanks Arthur
"Arthur Hanusek" wrote:
RMS,
I have just been having exactly this same error problem for the last few days since I upgraded my SQL Server 2005 Express. Whenever I restart my PC, the successful "Server name" changes. Thus, I have to try each one of the five following "Server name"s to get a successful "Database Connection" hit:
(local) MYPC MYPC\SQLEXPRESS xxx.xxx.x.x (I believe this is my PC IP address) xxx.xxx.x.x\SQLEXPRESS
Worse than that, I then accidently discovered that different credit & debit card sales listed under "Settle EDC Batch" under Utilities in SO Manager. So I am now settling any sales BEFORE I restart or shutdown my PC. Except for one batch of three credit card sales, I cannot get them back listed under the "Settle EDC Batch" screen. Luckily I have the 4-days old signed slips but I cannot settle them b/c they would never display again to settle.
I am suspecting something called SQL Server "instance"s as the culprit!? Any one can help!? Thanks,
------------------------------ "RMS" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.