Configure Griffon Projects in Workgroupx

screechingagendaΔίκτυα και Επικοινωνίες

26 Οκτ 2013 (πριν από 3 χρόνια και 11 μήνες)

69 εμφανίσεις

Configure Griffon Projects in Workgroup



COMP1

1.

Sql Express Service

a.

Change user to "Local System"

b.

Resta
r
t Service

2.

Sql Browser Service

a.

set to automatic

b.

Startup service

3.

Fire Wall Exceptions:

a.

c:
\
Program Files
\
Microsoft SQL Server
\
MSSQL.1
\
MSSQL
\
Binn
\
sqlservr.exe

b.

c:
\
Program Files
\
Microsoft SQL Server
\
90
\
Shared
\
sqlbrowser.exe

4.

SQL Server Configuration Manger

a.

Enable TCP/IP protocol

5.

SQL Server Surface Area Configuration

a.

Enable TCP/IP protocol

(Remote Connections
-
> Using TCP/IP only)

6.

Enable Mixed Mode

a.

HKEY_LOCAL_MACHINE
\
SOFTWARE
\
Microsoft
\
Microsoft

SQL
Server
\
MSSQL.1
\
MSSQLServer
\
LoginMode=2

7.

Create Login

CREATE LOGIN
Griffon

WITH PASSWORD = '
Griffon
', CHECK_POLICY=OFF;

USE
GriffonProjects
;

CREATE USER
Griffon

FOR LOGIN
Griffon
;

EXEC sp_addrolemember 'db_
owner', '
Griffon
'

8.

Reboot

Machine

COMP 2.
.
.n

1.

Configure
the client computer to use the shared Internet connection
:

a.

Click Start, and then click Control Panel.

b.


Click Network and Internet Connections.

c.


Click Internet Options.

d.


In the Internet Properties dialog box, click the Connections tab.

e.


Click the Setup button.

The New Connection Wizard starts.

f.


On the Welcome to the New Connection Wizard page, click Next.

g.


Click Connect to the Internet, and then click Next.

h.


Click Set

up my connection manually, and then click Next.

i.


Click Connect using a broadband connection that is always on, and then click Next.

j.


On the Completing the New Connection Wizard page, click Finish.

2.

Set connection string:

Data Source=
Comp1
\
SqlExpress;Ini
tial Catalog=
GriffonProjects
;
User ID=
Griffon
;Password=
Griffon