| Author |
MAC Address problem
|
|
| KathyM 2002-08-14, 10:23 am |
| Can anyone help??
System is configured with SQL 2000 and end-user is
utilizing a specialized application called Dealer 2000.
They are currenlty licensed for 10 users to use this
Dealer 2000 software. The software pulls the MAC address
when the client opens the software and leaves it in a
table. Once the table is full no one else is allowed to
login to the system. In the SQL Analyzer I can
run "select * from colic" and recieve a list of Mac
address and how many licenses are in use. The problem is
when 2 computers (same hardware as the remaining 8) login
it assigns a different address each time. This address
isn't even the machines MAC address of the nic - it
appears to be randomly assigning it. I can run in the SQL
Analyzer "update colic set nicaddr=null" and this will
reset all of the licenses again allowing the user to
login. It is becoming a big pain, but I don't know how to
fix it and the software vendor doesn't have any ideas
either.
Can anyone help??
Kathy
| |
|
| I may be way out in left field here, but is DHCP in the mix here somewhere?
"KathyM" <KathyMorgan170@msn.com> wrote in message
news:1ef301c243aa$6fcd1dd0$36e
f2ecf@tkmsftngxa12...
> Can anyone help??
>
> System is configured with SQL 2000 and end-user is
> utilizing a specialized application called Dealer 2000.
> They are currenlty licensed for 10 users to use this
> Dealer 2000 software. The software pulls the MAC address
> when the client opens the software and leaves it in a
> table. Once the table is full no one else is allowed to
> login to the system. In the SQL Analyzer I can
> run "select * from colic" and recieve a list of Mac
> address and how many licenses are in use. The problem is
> when 2 computers (same hardware as the remaining 8) login
> it assigns a different address each time. This address
> isn't even the machines MAC address of the nic - it
> appears to be randomly assigning it. I can run in the SQL
> Analyzer "update colic set nicaddr=null" and this will
> reset all of the licenses again allowing the user to
> login. It is becoming a big pain, but I don't know how to
> fix it and the software vendor doesn't have any ideas
> either.
>
> Can anyone help??
> Kathy
| |
| KathyM 2002-08-14, 11:23 am |
| Yes DHCP is installed on the 2000 Server, however I have
disabled it and set a static IP number on the 2 computers
in question because I also thought that may be an issue
but the problem still exists.
>-----Original Message-----
>I may be way out in left field here, but is DHCP in the
mix here somewhere?
>"KathyM" <KathyMorgan170@msn.com> wrote in message
> news:1ef301c243aa$6fcd1dd0$36e
f2ecf@tkmsftngxa12...
>> Can anyone help??
>>
>> System is configured with SQL 2000 and end-user is
>> utilizing a specialized application called Dealer 2000.
>> They are currenlty licensed for 10 users to use this
>> Dealer 2000 software. The software pulls the MAC
address
>> when the client opens the software and leaves it in a
>> table. Once the table is full no one else is allowed to
>> login to the system. In the SQL Analyzer I can
>> run "select * from colic" and recieve a list of Mac
>> address and how many licenses are in use. The problem
is
>> when 2 computers (same hardware as the remaining 8)
login
>> it assigns a different address each time. This address
>> isn't even the machines MAC address of the nic - it
>> appears to be randomly assigning it. I can run in the
SQL
>> Analyzer "update colic set nicaddr=null" and this will
>> reset all of the licenses again allowing the user to
>> login. It is becoming a big pain, but I don't know how
to
>> fix it and the software vendor doesn't have any ideas
>> either.
>>
>> Can anyone help??
>> Kathy
>
>
>.
>
| |
| KathyM 2002-08-14, 2:23 pm |
| Yes DHCP is installed on the 2000 Server, however I have
disabled it and set a static IP number on the 2 computers
in question because I also thought that may be an issue
but the problem still exists.
| |
|
|
|
|
| Neil Pike 2002-08-15, 2:23 am |
| Kathy,
Well the first is a real IBM card. The second isn't a "proper" mac address,
so something really has made it up.
Check the client with an ipconfig /all and confirm this isn't it's actual mac
address.
It must be some sort of switch/proxy/router between these clients and the
server that's changing the mac address - do you have a detailed network
diagram? Have you tried asking whoever supports the network there?
> A real mac address 000629f74414
> a random mac address ca5faf4957fa
>
> >-----Original Message-----
> >Kathy,
> >
> > Can you give me an example of a "real" and a "random"
> mac address?
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
|
|
|
|