We bought a new computer for departments system server, due to the problem of examination and approval, can only give department to install SQL express database version, now free, debug port and the inbound firewall rules, through the IP address can remotely access database,
But, in the later debugging found strange question:
Department some people can even go in, some people even don't go in, and branch of the people (not in the same province, but the same local area network) are even don't come in, I written in c # system, write dead connection string, the user use sa, is the highest level of administrators, how is the database set up problems, some people can not make sense to open the same system, some of them can't,
Asked if the IT company firewall Settings, answer is should not, says ought can access to IT, and the firewall IT doesn't matter, but why on earth would be so now, they also do not understand,
Very headache, holding the fluke mind help teachers, look to whether can help to analyze solution,
Thank ~ ~ ~ ~

CodePudding user response:

SQL express database version, free
Build a few more manage users, can,

CodePudding user response:

Can examine these questions on the link is not
https://blog.csdn.net/sinat_28984567/article/details/79549389

CodePudding user response:

reference 1st floor qq_457565758 response:

version SQL express database, free
User and, build a few more management

I am using sas user login, arguably, this is the biggest permissions ah,

CodePudding user response:

refer to the second floor February 16 response:

can examine these questions on the link is not
https://blog.csdn.net/sinat_28984567/article/details/79549389

Thank moderator, but looked at it and it should not be problems setting up the server database, because now is that some people can, some people on the ha

CodePudding user response:

snails to learn programming reference 4 floor response:

Quote: refer to the second floor of February 16 response:

can examine these questions on the link is not
https://blog.csdn.net/sinat_28984567/article/details/79549389

Thank the moderator, but looked at it and it should not be problems setting up the server database, because now is that some people can, on the part of people can't ha

Link up, use ping or Telnet test

CodePudding user response:

Not permissions, but the problem of users, up to the users, back in, put in front of the kick out, if there is no limit to the users, Microsoft can't do business

CodePudding user response:

refer to 6th floor qq_457565758 response:

is not a problem permissions, but the problem of users, the users, back in, and went out kick in front of, if there is no limit to the users, the company can't do business with

Should not, although express version for free, but it should not limit the number of users, and when we test the connection, connection number is three to five people, should not be users

CodePudding user response:

February 16 references 5 floor response:

Quote: snail to learn programming reference 4 floor response:

Quote: refer to the second floor of February 16 response:

can examine these questions on the link is not
https://blog.csdn.net/sinat_28984567/article/details/79549389

Thank the moderator, but looked at it and it should not be problems setting up the server database, because now is that some people can, on the part of people can't ha

Link up, use ping or Telnet test

Webmaster hello, for the port in the system background, really don't understand, look at the link, as if just say this way to test, but after test, how to determine or how to solve the problem? Could you help me read?
Thank you ~

CodePudding user response:

In the provincial branch, if your company IP dial is of course not