If your SQL Server is SERVERNAME\SQLEXPRESS, it's a named instance and
is running on a non-standard port. You'll need to find out what port
SQL Server Express is running on, and enter that in the appropriate box
on the datasource configuration screen. Also, just use SERVERNAME for
the name of the server, not SERVERNAME\SQLEXPRESS.
HTH,
Carl
On 7/19/2011 9:30 AM, Daniel Eng wrote:
Well, somehow I don't have to enter that in my ODBC datasource. I just
select it from a list and it reads like this: NAME\SQLEXPRESS. How do
I figure out the IP address of my SQL Server? It is different from my
server IP right?
Daniel
On Wed, Jul 20, 2011 at 12:19 AM, Matthew Woodward
<[email protected] <mailto:[email protected]>> wrote:
On Tue, Jul 19, 2011 at 9:11 AM, Daniel Eng <[email protected]
<mailto:[email protected]>> wrote:
But how do I know what to key in for Database Server?
This is the host name or IP address of your SQL Server. I assume
you have to enter that in your ODBC datasources too, no?
I do not have to enter Username and Password right?
Yes, you do.
--
Matthew Woodward
[email protected] <mailto:[email protected]>
http://blog.mattwoodward.com
identi.ca <http://identi.ca> / Twitter: @mpwoodward
Please do not send me proprietary file formats such as Word,
PowerPoint, etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
