| Author |
Topic |
|
johng388
Starting Member
3 Posts |
 Posted - 2007-06-14 : 20:19:15
|
| I have just installed SQL Express Server 2005.I can access the server through the internal network but i cannot access it over the internet. I believe it is an issue with our router. Does anyone know which ports need to be opened to allow access. Or is it something else?John |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-14 : 20:32:49
|
| You can find port number it is listening on in sql server log. |
 |
|
|
johng388
Starting Member
3 Posts |
Posted - 2007-06-15 : 19:33:37
|
quote:
Originally posted by rmiao
You can find port number it is listening on in sql server log.
The log only shows me errors, do i need to change a setting? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-15 : 22:54:22
|
| Can you post it? |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-06-16 : 16:47:40
|
| sql listens on port 1433check a few things.1. Do you have a firewall and if sql server is blocked or not ?2. To check which ports are open run the netstat utility in command prompt |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-16 : 17:23:30
|
| Sql2k5 express uses dynamic port by default. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-06-17 : 02:24:24
|
quote:
Originally posted by rmiao
Sql2k5 express uses dynamic port by default.
very sorry, was thinking of sql2000 |
|
|
|
Lantier
Starting Member
1 Post |
Posted - 2007-06-17 : 13:55:48
|
| Can you help me please ? CREATE TABLE [dbo].[NguoiTimViec]( [NguoiTimViecID] [int] IDENTITY(1,1) NOT NULL, [HoTen] [nvarchar](50) NOT NULL, [NgaySinh] [datetime] NOT NULL, [QuocTich] [ntext] NULL, [DiaChi] [ntext] NOT NULL, [QuocGia] [nvarchar](20) NOT NULL, [ThanhPho] [nvarchar](30) NOT NULL, [DienThoai] [varchar](13) NOT NULL, [Email] [varchar](50) NOT NULL, [MatKhau] [varchar](12) NOT NULL, [NhomNguoiDungID] [int] NOT NULL, CONSTRAINT [PK_NguoiXinViec] PRIMARY KEY CLUSTERED ( [NguoiTimViecID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]but when i excuted, NGUOIXINVIECID began with 12 --> 14 --> 15 --> 16Can you teach me how i can correct it ? ^^ thank so much |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-17 : 15:26:32
|
| What do you mean? Didn't create table? Any error message? |
|
|
|
johng388
Starting Member
3 Posts |
Posted - 2007-06-17 : 22:19:58
|
quote:
Originally posted by rmiao
Can you post it?
How can i attach the log?John |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-06-17 : 22:23:07
|
quote:
Originally posted by johng388
quote:
Originally posted by rmiao
Can you post it?
How can i attach the log?John
You can't attach it. Can you just copy and paste the error message here ?
KH |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
SQL Express Server 2005