Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts

Friday, March 30, 2012

northwinds wher can i get it?

does anyone know the link to get the northwinds db for sqlserver?
(i need it for sql2005)
thanks
kes
Northwind for 200 can be downloaded here:
http://www.microsoft.com/downloads/i...LinkId%3d30196
Aventureworks (2005) is located here:
http://www.microsoft.com/downloads/i...5f8%2fAdventur
eWorksDB.msi
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Kurt Schroeder" <KurtSchroeder@.discussions.microsoft.com> schrieb im
Newsbeitrag news:DBE378AF-1576-4998-9A8D-94BAE208AAFF@.microsoft.com...
> does anyone know the link to get the northwinds db for sqlserver?
> (i need it for sql2005)
> thanks
> kes
sql

Monday, March 12, 2012

Non Windows App connecting to SQL Server using Windows Auth

How can a non Windows App , say an app that runs on Linux connect to SQL
Server using Windows Auth ?
Has anyone done that ? How does Linux integrate with Windows ? Are there 3rd
party tools ?
We know SQL Auth would work but we want to use Windows Auth only.
Please let me know
ThanksTypically a Linux box uses something like FreeTDS to connect to a SQL
Server machine. FreeTDS supports both forms of authentication:
http://www.freetds.org/faq.html

Non standard port - non default instance

Hi all,
I'm trying to create a subscription for a merge replication on a sql
server mobile 2005 based application.
The publisher is on a intranet, listening on port 9091 and with a named
instance.
The merge agent is in a DMZ with port 9091 open for inbound/outbound TCP
traffic to the intranet.
Problem:
when I try to synchronize I receive the "SQL Server does not exists" error.
My subscription has the following setup:
Publisher = "ServerName\InstanceName";
PublisherNetwork = NetworkType.TcpIpSockets;
PublisherAddress = "10.xxx.xxx.xxx,9091";
PublisherDatabase = "DatabaseName";
PublisherSecurityMode = SecurityType.DBAuthentication;
PublisherLogin = "name";
PublisherPassword = "pwd";
name/pwd user has correct priviledges non publisher database.
I can connect via SQL Client to the database from the machine in DMZ.
In my (many) tries, I also created an alias on the DMZ client and used
that for the Publisher property at the subscriber.
Nothing worked.
I'm finishing options...
Cl@. ha scritto:

> Problem:
> when I try to synchronize I receive the "SQL Server does not exists" error.
I solved opening 1434 udp port.
Question is: why sql client can connect without 1434 port open and the
merge agent can't?