how to connect to SQL Server 2014

Question

Post reply

how to connect to SQL Server 2014

Viewing 15 posts - 16 through 30 (of 39 total)

You must be logged in to reply to this topic. Login to reply

dukanif SSC-Addicted Points: 408 More actions · Answer 1

but how can i connect to SQL Server if not use ODBC?

i used access yet but now i want use SQL Server such as main server to save data .

thanks

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

dukanif (5/17/2016)
but how can i connect to SQL Server if not use ODBC?
i used access yet but now i want use SQL Server such as main server to save data .
thanks

If you are making a connection to SQL Server using Access you will need to create an ODBC connection.

You either create a Data Source Name (easier) or create the connection in Code.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

jasona.work SSC Guru Points: 50118 More actions · Answer 3

Welsh Corgi (5/17/2016)
dukanif (5/17/2016)
but how can i connect to SQL Server if not use ODBC?
i used access yet but now i want use SQL Server such as main server to save data .
thanks
If you are making a connection to SQL Server using Access you will need to create an ODBC connection.
You either create a Data Source Name (easier) or create the connection in Code.

Additionally, you may need to point the ODBC connection to the IP address of the server, rather than the name. Which you can use will depend on the configuration of the VPN / VPN Client.

Tim Curtin Say Hey Kid Points: 665 More actions · Answer 4

SQL Server is a backend server. SQL Server Management Services (SSMS) is a client app for administering databases. If you are creating an application, then you would need to create some application (Access, .Net, web, etc...)

Access is somewhat of a rich client in that you can develop screens and reports and macros to navigate between them and fairly rapidly due to its built-in wizards.

dukanif SSC-Addicted Points: 408 More actions · Answer 5

yes i know that i must create ODBC connector , but when i creat it not find server , please see this picture

jasona.work SSC Guru Points: 50118 More actions · Answer 6

dukanif (5/17/2016)
yes i know that i must create ODBC connector , but when i creat it not find server , please see this picture

You need to key in the name or IP address of the server there, it won't automatically "find" it through a VPN (and potentially even on the same network as the server it wouldn't find it.)

If you don't know the name / IP of the server, you'll need to get it from someone who does.

dukanif SSC-Addicted Points: 408 More actions · Answer 7

i know server IP and Server Name but cannot connect .

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

dukanif (5/17/2016)
i know server IP and Server Name but cannot connect .

Can you ping the Server?

Can you remote into the Server?

Edit: What error are you getting?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

dukanif SSC-Addicted Points: 408 More actions · Answer 9

Can you ping the Server?

Can you remote into the Server?

yes

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 10

dukanif (5/17/2016)
Can you ping the Server?
Can you remote into the Server?
yes

Does the account that you are using have permissions to the Server?

Is SQL Server installed on a Default Instance?

If so are you using the IP Address?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 11

Is SQL Server set up to allow remote connections?

Is the client computer (the desktop / PC) on the same network and subnet as the Server or a different one?

What about the domain? Is it the same or different between the two?

If different domains, do they trust each other?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 12

I would check the permissions on the account that is being used to connect to that instance.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Tim Curtin Say Hey Kid Points: 665 More actions · Answer 13

what version of SQL Server did you install? It looks like a permissions error.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 14

It appears to be an authentication issue.

Check permissions.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 15

Welsh Corgi (5/18/2016)
Echo.

That was terribly rude of you. Especially given how you tend to respond when other people try to help you with your questions.

In the future, please try to be nicer to people, especially newer people who are actually trying to learn by helping other people.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.