MSSQL: Remote Connection and Multiple Users?

Customer Support Database Support
1

Dear Jodohost Admin,

For MSSQL, do you allow remote connection and multiple users with different privileges? What I would like to have is the ability to connect to the MSSQL DB at Jodohost from other web sites using a user account with only “select” right. Thanks for your help in advance.

Winnie

2

Yes, you can do that. You can create unlimited MS SQL users with different access rights

3

[QUOTE=Yash]
Yes, you can do that. You can create unlimited MS SQL users with different access rights
[/QUOTE]

Thanks for your quick reply. How about remote connection? This is a must for me since the web application I’m developing needs this to work.

Winnie

4

Yes, you can connect to our MS SQL servers from anywhere in the world

5

Hi Yash,

I’ve been playing around with the trial account. The server is great but I have trouble connecting to the MSSQL DB remotely using the DAAB in ASP.NET. It gave me the access denied error when I tried to connect from a site not at JodoHost. I can connect to it from my JodoHost site though. The connection string I use is this:

“Data Source=mssql3.jodohost.com;Initial Catalog=xxxxx;UID=xxxxx;PWD=xxxxx”

The "xxxxx"s are my database name and login details. Any help is appreciated.

Winnie

6

Winnie

We have placed no restrictions on our SQL server and you can access it from any server in the world. But the access method may need to be altered for it to work. Unfortunately, we do not have any ASP programmers at the moment and can’t help you with this.

7

Re: Re: MSSQL: Remote Connection and Multiple Users?

I use this type of connection to SQL server in ASP.NET - it works:

server=MSSQL2.JODOHOST.COM;database=MyDB;uid=xxx;pwd=xxx

8

Re: Re: Re: MSSQL: Remote Connection and Multiple Users?

[QUOTE=StPatrick]
I use this type of connection to SQL server in ASP.NET - it works:

server=MSSQL2.JODOHOST.COM;database=MyDB;uid=xxx;pwd=xxx
[/QUOTE]

Have you succeded in remote connection from off-server sites? I have tried every possible combination of connection string.. but still no luck
;(

9

well, i can connect to my database fine from aspenterprisemanager.com so I don’t think that JodoHost doesn’t allow remote connections

10

Re: Re: Re: Re: MSSQL: Remote Connection and Multiple Users?

Haven’t tried from other sites, but SQL Server Enterprise Manager and Query Analizer are working.
But are you sure that another site allows you to connect to outside SQL server?

11

Any Luck - could u find the solution.

I am facing the same problem - have tried all options - as in added dbscon etc … tried using TCP/IP … but the database is not connecting !!!

Regards,
Ani

12

Kindly, once send us a ticket with link in which you are getting database connection error. So, we can check it.